Re: Drop file from SYSTEM tablespace

First of all, the most easy thing to do is shutdown and restart with RESTRICT mode, and do the full EXPort, then Shutdown the database and drop/delete all datafiles belonged to the database. Recreate the database and run the IMPort. The process is long/short depended on how much/big is your export file.
Second, if you want to create a rollback_segment, for GOD's sake as well as for everybody using the database, NEVER created one on SYSTEM tablespace, except the first one when you create the database. Create a RollBACK tablespace and put all of rollback_segments in here (except one belong to the SYSTEM tablespace).

Good luck.

klimsamgin wrote:
>
> Hi!
>
> I work with ORACLE 7.3 on Solaris 2.5.
>
> Accidentally I added very big file (100Mb) to the SYSTEM tablespace
> (I prepared this file for the ROLLBACK segment,
> but the worse thing happened :-()
>
> To drop this file from SYSTEM tablespace I must
> turn SYSTEM tablespace OFFLINE, but this tablespace
> must always be ONLINE.
>
> How to do this operation?
> How to ensure that this file doesn't contain any important
> information and file dropping will not impact to the database?
>
> Thanks,
> Klim.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jun 10 1999 - 12:18:25 CDT