Drop a table with foreign key constraints

Hello,

I want to make some changes in a table, like changing the order and type of its 
columns, adding some new columns after or before some specified columns and so 
on, but I understood that this is not possible in Oracle without re-creating 
the table.

Because of this, I want to drop the current table and create a new one, but 
many other tables have foreign keys that depend on this table, so it can't be 
dropped easy.

I know that I could just use
drop table table_name cascade constraints;
but this would drop all the constraints from those many tables and it would be 
hard to re-create them again (and I might miss some of them).

Is there a way of disabling all the constraints regarding the table that should 
be deleted, drop the table and then enable the constraints again in an easy way?

Thanks.

--
Octavian



__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 5324 (20100729) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Other related posts: