Oracle FK

select
owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
from all_constraints
where constraint_type in (‘P’,’U’)
and table_name=’table_name’;

sumber :
1. http://www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm

Oracle listener

Jika menginstall oracle database stadard (bukan XE), listenernya harus di bind ke 0.0.0.0 secara manual di Oracle Net Manager. Tambahkan ip 0.0.0.0 untuk membind secara otomatis IP pada server ke listener oracle.