Hi Eric,
Try brining the database up no mount then issue:
alter database drop tablespace rbs;
Then mount it.
HTH,
- Eric Fang <eric_fang_at_yahoo.com> wrote:
> I accidently deleted the datafile for a rollback
> segment. I got the error of Ora-01157: Can not
> identify data file 6.
> How can I bring the database up if I don't have
> backups(I don't care whether I am going to lose data)?
>
> Thanks in Advance.
>
> Eric Fang
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Eric Fang
> INET: eric_fang_at_yahoo.com
>
> 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).
>
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Thu May 18 2000 - 12:48:33 CDT