Re: deleted undotbs01.dbf...

From: de12261 <de12261_at_gmail.com>
Date: Wed, 01 Aug 2007 07:50:08 -0700
Message-ID: <1185979808.374552.114860@k79g2000hse.googlegroups.com>

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 Received on Wed Aug 01 2007 - 09:50:08 CDT