Re: deleted undotbs01.dbf...

On Aug 1, 10:50 am, de12261 <de12..._at_gmail.com> wrote:
> On 1 Ago, 16:30, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > Since the only rollback segment available would be the SYSTEM rollback
> > segment I doubt even that would get this database open; it might allow
> > it to mount, however, which may be enough to create a new undotbs1.dbf
> > file.
>
> > It's probably worth a try; as I said earlier any port in this storm is
> > better than no port at all.
>
> > David Fitzjarrell
>
> Hello
>
> i cannot open...
> when I try "alter database open" it gives me the error ORA-01092:
> oracle instance terminated....
>
> so I cannot create a new undo tablespace...
>
> is there any other solution to recreate a tablespace????
>
> they do not have a backup ...
>
> :-(
>
> thank you

Try this

SQL> startup mount

SQL> Alter database datafile < datafile path or file number> offline drop;

SQL> alter database open;

Then

• create a new Undo Tablespace
• Make the newly created Undo tablespace as default undo tablespace
• drop the old undo tablespace.

Thanks,
Krishna Received on Wed Aug 01 2007 - 10:13:37 CDT