Re: System used as holiday camp!!

1. do a full schema export
2. drop user
3. recreate user with different default and temporary tablespaces and NO = quota on system
4. import schema. The users is now moved.

>>> <mleith_at_bradmark.co.uk> 05/03/00 06:07AM >>>
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..=20

Any insight is greatly appreciated!

TIA Mark

--
Author:
  INET: mleith_at_bradmark.co.uk=20

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).