Re: DROP or MODIFY COLUMN on Oracle 8 system

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 12 May 2006 07:34:10 -0700
Message-ID: <1147444450.178553.284610@y43g2000cwc.googlegroups.com>

Brian Peasland schreef:

>
> > 3. Drop old table
> > problem: how can i drop it, when its PK has references?
>
> Before you drop the table, make sure you have everything you need to
> recreate it. You'll have to reverse-engineer the CREATE TABLE statement.
> Don't forget to reverse-engineer any CREATE INDEX and ALTER TABLE ADD
> CONSTRAINT statements for that table as well. Make sure you can recreate
> any triggers on that table. Those triggers might use a sequence, but
> dropping the table will not drop the sequence so you do not have to
> recreate the sequence.

Don't drop it, rename it. Do the same for the _TEMP table, and you're done, iirc.
FK's, PK's and the like will be OK; PK index not

You can easily test this on a small table. Asktom has entries on this subject - did you search? Received on Fri May 12 2006 - 09:34:10 CDT