RE: Droping System User

>-----Original Message-----
>From: Nirmal Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa]
>
>I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before.

>Now i shutdown my database and startup again, here the problem arises. Oracle mount the database but while opening the database, the instance has been terminated by PMON.

>Sat Oct 20 10:57:45 2001
>PMON: terminating instance due to error 470
>Instance terminated by PMON, pid = 316
>Oracle posted the following error continuosly in the alert log:
>SMON: following errors trapped and ignored:
>ORA-00376: file 1 cannot be read at this time
>ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF'
>Am crusious, come to know what type of problem you have faced?....

Did you trop the user SYSTEM and also try to drop the tablespace SYSTEM, or else remove the datafiles in tablespace SYSTEM?

Removing the system tablespace, or a datafile in the system tablespace, is bad news indeed. Removing only the SYSTEM user can be fairly harmless (though of course never recommended), depending, of course, on what objects you have installed under user SYSTEM. Received on Mon Oct 22 2001 - 12:15:02 CDT