Re: how to boost drop table statement

John Currier wrote on 18.06.2005 20:22: 
You could try to TRUNCATE the tables first, but then they must not have
foreign key constraints.



You just have to do them in the correct order (assuming no recursive
constraints).

<plug>
SchemaSpy grew out of a tool that I wrote to determine that order.
It'll generate insertion order and deletion order lists of tables that
are intended to be used by load/purge scripts.
</plug>


No that won't help. There is a limitation on the usage of TRUNCATE with Oracle.

Quote from the manual (9.2):

"You cannot truncate the parent table of an enabled referential integrity constraint. You must disable the constraint before truncating the table."

Even if the order is right, it won't help here.

Thomas
.