Re: deleted undotbs01.dbf...

On 1 Ago, 17:13, Krish <Krishna.Bu..._at_gmail.com> wrote:
> > On Aug 1, 10:50 am,de12261<de12..._at_gmail.com> wrote:
> > 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

thanks

I tried but when "SQL> alter database open;" i got the error ORA-01092

:-( Received on Wed Aug 01 2007 - 10:19:42 CDT