Re: ORA_01001: invalid cursor Error on a CLONE Database

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 5 Aug 2003 02:25:12 +0300
Message-ID: <3f2eeb59$1_1@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.

Tanel. Received on Mon Aug 04 2003 - 18:25:12 CDT