Re: ORA_01001: invalid cursor Error on a CLONE Database

"Tanel Poder" <tanel@@peldik.com> wrote in message news:3f2eeb59$1_1_at_news.estpak.ee...
> > The above error is given because you were using the system rollback
> > segment and you can't use this one for this particular operation. You
> > need to use a non-system rollback segment. If you are using a system
> > rollback segment, then it is highly likely that you don't have any
> > non-system rollback segments online and available, so the database used
> > the only one it had. So make sure that you have non-system rollback
> > segments online and ready for use.
>
> Hi!
>
> You can't have any non-system rollback segments (nor undo segments) online
> in a clone database (when using alter database mount clone database).
>
> The ORA-1552 comes because bug 2621039. It's few weeks old, not fixed, nor
> there's any quick workaround yet. Just monitor the bug, or rethink your
> strategy until the bug is fixed.

Thanks for the info!

Sorry for the silly question, but how do I monitor the bug and get the fix when it becomes available?
I am doing this exercise for educational purposes in prep for the 9i DBA Admin II exam. (I realize that a clone database is not covered for Admin II).

Richard
>
> Tanel.
>
>
Received on Mon Aug 04 2003 - 21:04:18 CDT