SQL Home Board Archive Index General Excel Questions 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.