OraFAQ Forum: Server Administration » Dropping multiple tables.

Home » RDBMS Server » Server Administration » Dropping multiple tables.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dropping multiple tables. [message #64566]

Tue, 08 February 2005 20:21

raghukalyan
Messages: 44
Registered: May 2004

Member

hi ,

Is there any way to drop more than one table at a time..

Hoping for a quick response.

Regards,
GRK

Report message to a moderator

Re: Dropping multiple tables. [message #64568 is a reply to message #64566]

Tue, 08 February 2005 21:44

Frank
Messages: 7901
Registered: March 2000

Senior Member

drop user ... cascade will drop more than 1 table using a single statement.
You could generate a script by coding a

set heading off
set linesize 200
set pagesize 0
set echo off
set feedback off
spool drop_them.sql
select 'drop table '||table_name||';'
from   all_tables
where  table_name like 'Idontknow%'
/
spool off
@drop_them

hth

Report message to a moderator

Previous Topic:	Table and index size
Next Topic:	Please help me with this proc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:22:45 CDT 2024