ORA_01001: invalid cursor Error on a CLONE Database

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 Received on Thu Jul 31 2003 - 13:29:00 CDT