Re: how to boost drop table statement

Lee Fesperman wrote on 19.06.2005 22:23:
Assuming no cross-referencing referential integrity, ordering would truncate the table containing the FK reference first, thus it would seem to work.
No. As long as there is a FK referenced *defined* Oracle will refuse to truncate a table.

Apparently, Oracle doesn't support the CASCADE option for DROP, which would eliminate the similar ordering problem when using a list of DROP TABLEs. It also solves the cross-referencing problem. Lack of standards support does have its consequences ;^)


Oracle does support the CASCADE option for DROP... But then we're back to the question on how to speed that up.

Thomas
.