If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I'm having problems cleaning out a schema. i keep getting the following errors:
ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

I've run the script severeal times, and it keeps coming up with the same thing.

When i run your script, it doesn't disable the constraint, it's as if nothing happens. ive spooled it into a file and tried to run the file, but when i check for 'enabled constraints' the same ones are still there??

sreddy,

I've been using a very similar script to clean up a schema... but it's just not removing all objects