dropping foreign key constraints

From: Jeff <javellanet_at_my-dejanews.com>
Date: Tue, 20 Apr 1999 19:22:22 GMT
Message-ID: <7fik5a$99s$1@nnrp1.dejanews.com>

I need nuke all the data in my the development instance of my Oracle 8 server and use SQL*Loader to re-load accurate data from an outside non-Oracle system.

My question is... does anyone have a script that drops all foreign key constraints in a database and then another script that can re-add them? I'm wondering if there's a way to do this by using the system catalog tables such as user_constraints ... maybe?

--

Jeff Avellanet
Database Application Developer
Washington, DC

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 14:22:22 CDT