Re: System used as holiday camp!!

Just export them, change the users default tablespace to whatever you want, remove any quota on the system tablespace, and drop the tables and import them into the right tablespace.

HTH
Ruth
----- 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 6:07 AM
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).