Re: System used as holiday camp!!

Hi,

The following statement produces the script you need.

SELECT 'DROP TABLE ' || Table_Name || ' CASCADE CONSTRAINTS;' FROM Dba_Tables
WHERE Owner = '[User_Name]'
  AND Tablespace_Name = 'SYSTEM';

HTH
Dima

• Original Message ----- From: <mleith_at_bradmark.co.uk> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 03, 2000 1:07 PM Subject: System used as holiday camp!!

> Hey Guys & Gals
>
> Taking a look at a system tablespace today on one of our test machines,
and it seems a user was created by sys!! Thus making this little blighters default tablespace.. you guessed it.. system. Now this oh so clever user has created about 200 tables and indexes alike in the system tablespace!
>
> What I am wondering is this, do any of you have a script that can delete
all of a users objects from a tablespace? I don't want to play around to much with the system tablespace as my knowledge is limited..
>
> Any insight is greatly appreciated!
>
> TIA
>
> Mark
>
> --
> Author:
> INET: mleith_at_bradmark.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
Received on Wed May 03 2000 - 06:05:54 CDT