Not sure how to explain this, but I'll give it a shot.

Need to populate 300+ Oracle tables, many of which have foreign keys, so I need to establish a sequence in which data is loaded into these tables so that the constraints are not violated.

Can anyone help with a SQL query that will help me identify the following?

1) name of foreign key constraint
2) name of table containing a foreign key
3) name of parent table referred to by the foreign key
4) name of column(s) in parent table referred to by the foreign key

From this info I', HOPING I can construct a proper load sequence.

Any other suggestions are certainly welcome.