| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: System used as holiday camp!!
I don't think I'd bother about the objects themselves - I'd maybe take a
user level EXPORT as a backup first then drop / recreate the user (with a
different default tablespace!) ???
> ----------
> From: mleith_at_bradmark.co.uk[SMTP:mleith_at_bradmark.co.uk]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: 03 May 2000 11:07
> To: Multiple recipients of list ORACLE-L
> 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).
>
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
 |
 |