Re: Drop a table with foreign key constraints

<drop and recreate table the way you need to. (make sure data is back)>

set constraints all immediate;

Mike

Octavian Rasnita wrote:
> 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

--
http://www.freelists.org/webpage/oracle-l