Don't do the table reorgs this way, particulary if you are on 8i. It is almost 100% you will forget something - you have to take care of:
indexes,
PKs,
UKs,
check constraints,
FKs from this table,
FKs from other tables referencing this table,
triggers,
grants,
snapshot logs,
etc etc...
Why not simply use ALTER TABLE MOVE command - you will only have to rebuild (not recreate!) indexes, everything else will be taken care of by the system.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote