hi there

my server win 200 and oracle 816 crashed yesterday. After recovering with emergency disc, i found that one of my rollback segnments has been deleted or crashed. I couldn't find it. Now the application which uses oracle as back end takes a seperate kind of backup, so not possible to revoer the dbf file from there.

Is there anyway to recover a database where the one of the rollback segments has been deleted , and the database is in NoArchive Log Mode.

any help would be appreciated ????


thankx
ICEMAN