Oracle - drop table constraints without dropping tables

I'm doing some bulk migration of a large Oracle database. The first step of this involves renaming a whole load of tables as a preparation for dropping them later (but I need to keep the data in them around for now). Any foreign key constraints on them need to be dropped - they shouldn't be connected to the rest of the database at all. If I were dropping them now I could CASCADE CONSTRAINTS, but rename simply alters the constraints.

Is there a way I can drop all of the constraints that CASCADE CONSTRAINTS would drop without dropping the table itself?

11
задан Submonoid 13 September 2010 в 14:18
поделиться