No specific way of deleting selected multiple objects as far as I am aware.
You could drop a tablespace including contents if you wanted to delete all
objects in that tablespace or you can drop user cascade.
The best bet is to create some dynamic sql to just create a script
Something like the following will do it
select 'drop table '||table_name||';' from user_tables where table_name in
('TABLEA','TABLEB' etc);
or
select 'drop table '||table_name||';' from user_tables ;
and then spool the list to a file and delete all the lines you are not
interested in.
This is 8i and below , I don't know what version you are on and there might
be something new in 9i but somehow I doubt it as normal mode is either to
delete a selected table or delete all tables from a user or tablespace
John
-----Original Message-----
Sent: 22 October 2002 10:34
To: Multiple recipients of list ORACLE-L
What is the syntax to delete multiple objects, or more specifically multiple
tables from a user in 1 go.
I need to delete 50+ tables/objects without deleting them 1 by 1.
Thanks
Clint
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
