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?