Drop file from SYSTEM tablespace

From: klimsamgin <klimsamgin_at_yahoo.com>
Date: Fri, 28 May 1999 15:13:18 GMT
Message-ID: <7imbqb$m1r$1@nnrp1.deja.com>

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 Fri May 28 1999 - 10:13:18 CDT