Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.

This story continues at
http://www.dbasupport.com/oracle/ora...raints02.shtml