Re: Is there a solution for this problem ?

Hi,

    No guarantees but try this:

1. create a new tablespace for additional rollback segments
2. Create at least one new rollback segment in the new tablespace
3. Alter each of your existing rollback segments offline
4. Alter the database and drop the offending data file.
5. Alter your rollback segments online

regards
jerry gitomer

andres wrote in message <38091A45.BD56E411_at_ix.netcom.com>...
>Hello all,
>
>Could I recover a database that had a block corruption in the
file that
>serves as the tablespace for rollback segments
>I am trying to create a new segment for rollbacks but the server
hangs
>for minutes apparently without doing anything at all.
> Thanks and regards,
>andres
>
Received on Mon Oct 18 1999 - 12:03:24 CDT