Re: Having a fast way to drop a 10G bytes tablespace ?

On 13 Oct 1999 16:58:23 GMT, dhall0419_at_aol.com (Dhall0419) wrote:

>Use the truncate table command first. It quickly empties the table without
>creating redo. Then delete the table.
>HTH
That is if it's only the one table.

Try :-

spool trunctab.sql

select 'truncate table '||table_name||';' from dba_tables
where tablespace_name = '<TABLESPACENAME>';

spool off;

@trunctab

Then try the drop tablespace command and rm the datafile(s).

Jason. Received on Wed Oct 13 1999 - 12:10:26 CDT