SQL


Posted by Phil on January 11, 2002 3:32 AM

Does any1 know the SQL to drop all my tables in Oracle 8i in one go...

Thanks

Posted by Mark W. on January 11, 2002 8:08 AM

Did you try DROP TABLESPACE or DROP CLUSTER?

Posted by phil on January 11, 2002 8:29 AM

Niether, which one drops them all at once... (bearing in mind that there are joins etc...

cheers

phil



Posted by Mark W. on January 11, 2002 8:45 AM

Both... All the tables in the TABLESPACE or CLUSTER.