Re: ORA_01001: invalid cursor Error on a CLONE Database

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 31 Jul 2003 18:50:34 GMT
Message-ID: <3F2964FA.DB104FF7@remove_spam.peasland.com>

The following from the docs:

Error: ORA-25153 Text: Temporary Tablespace is Empty

---

Cause: An attempt was made to use space in a temporary tablespace with no
files.
Action: Add files to the tablespace using ADD TEMPFILE command.

Does this help?

Brian

Richard Kinread wrote:
>
> I am running Oracle 9i 9.2.0 on Red Hat 7.3 and am trying to do user-managed
> TSPITR and get the following errors when I execute transport_set_check: (I
> am disappointed that the error messages aren't clearer.
>
> SQL> execute dbms_tts.transport_set_check('users', true);
> BEGIN dbms_tts.transport_set_check('users', true); END;
>
> *
> ERROR at line 1:
> ORA-01001: invalid cursor
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
> ORA-06512: at "SYS.DBMS_SQL", line 19
> ORA-06512: at "SYS.DBMS_TTS", line 774
> ORA-25153: Temporary Tablespace is Empty
> ORA-06512: at "SYS.DBMS_TTS", line 803
> ORA-06512: at line 1
>
> I believe I have done all of the prereq steps correctly - copied backup
> control file, backup datafiles and current logs, mounted a clone database,
> recovered to a point in time before failure, and opened the database and
> reset the logs.
>
> I also received almost the same set of messages when I tried to export the
> users tablespace metadata. (Second last error message above is replaced by:
> ORA-06512: at "SYS.DBMS_PLUGTS", line 1093
>
> Any help would be much appreciated.
>
> Thanks,
> Richard

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Thu Jul 31 2003 - 13:50:34 CDT