Hi, your error more resembles a media failure than anything else. Check the status column from v$datafile. since this is the system datafile u seem to have lost,you would need a closed full db recovery .. i.e. is you care to recover your test db :)
Deepak PS: did you delete the system datafile instead of the system user? --- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> wrote: > hi .... > > 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?.... > > Regards, > Nirmal > > -----Original Message----- > > From: Jacques Kilchoer > [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, October 05, 2001 12:30 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Droping System User > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [ > <mailto:[EMAIL PROTECTED]>] > > > > > > Dropping the SYSTEM user is not really all that > traumatic. > > > > > > In most cases it's just a DBA account that may > own some pieces you'd > > > rather not lose, but dropping SYSTEM will not be > noticed by the users > > > of the database. > > > > > > That's the impression I get. When I looked at the > objects owned by SYSTEM > > in my test database before the drop, none of them > seemed vital. > > > > On the other hand, dropping sys would probably be > bad, but I wasn't able > > to do that (insufficient privileges.) > > Trying to drop sys tables like sys.user$ caused an > ORA-00701. > > So since I'm on a quest to wound this database, I > tried this: > > > > SQL> delete from sys.user$ where name = 'SYS' ; > > 1 ligne supprimée. > > SQL> commit ; > > Validation effectuée. > > > > So far no ill effects! > > > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
