Operating System - HP-UX
1753483 Members
4261 Online
108794 Solutions
New Discussion

Error while performing TSPITR

 

Error while performing TSPITR

Hi all,
i am performing user managed TSPITR. i was able to recover the auxilliary instance but however while transporting the tablespace i got the following error

----------------------------------------------
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 1001 encountered
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_PLUGTS", line 1093
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
---------------------------------------------
i have put the tablespace in read only mode and also checked TRANSPORT_SET_VIOLATIONS table for any violations. it says no rows selected. but still i m getting this error.

Any quick help will be highly appreciated.

Thanks & Regards
Subodh