Re: Drop all the objects inside a tablespace.

From: Bryant <btolar_at_fedworld.gov>
Date: 22 Aug 2001 11:25:21 -0700
Message-ID: <b0bb806d.0108221025.14955285@posting.google.com>

guptap_at_synygy.com (Prabuddha) wrote in message news:<567752f5.0108220628.260d53f4_at_posting.google.com>...
> Hi All,
> I want to drop all the tables inside a tablespace without dropping the
> tablespace.So that after dropping the old tables,I can create new
> tables inside that tablespace. Is there a way?
>
> Thanks in advance.
> Prabuddha

One solution is to create SQL from SQl

set heading off
set pagesize 0

spool drop.sql
select 'drop table '||table_name||';'||
from dba_tables
where tablespace_name = 'WHATEVERTABLESPACE'; spool off

Then run the drop.sql

B Received on Wed Aug 22 2001 - 13:25:21 CDT