dropping tables in a tablespace

Hi folks,
I am trying to do a fresh import of data into a tablespace. Right now I want to
get rid of all the tables (250 of them) in this tablespace as it I want to import
the tables afresh.

How do I drop all tables in a tablespace? I know how to drop a tablespace...
but that means I would have to create new tablespaces with the right parameters
from the beginning. I want to be able to clear out all the data (tables, indexes
views....etc.) in a tablespace all at once. Is there a command to do that?

Thanks,

-Sudarshan Received on Tue Sep 21 1999 - 14:29:50 CDT