TMS Export Fails With ORA-01000: maximum open cursors exceeded
(Doc ID 1271760.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Thesaurus Management System - Version 4.5.0.0.7 to 4.6.1 [Release 4.5.0 to 4.6.1]Information in this document applies to any platform.
Symptoms
TMS 4.5.0.0.7
Export is failing with the below message:
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VTA_GLOBAL_FLAG204_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VT_SUBTYPE109_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VT_SUBTYPE206_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table WARNING_ROW104_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table WARNING_ROW201_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA106_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA203_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA_NAME105_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA_NAME202_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VTA_GLOBAL_FLAG204_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VT_SUBTYPE109_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table VT_SUBTYPE206_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table WARNING_ROW104_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table WARNING_ROW201_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA106_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA203_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA_NAME105_TAB
EXP-00056: ORACLE error 1000 encountered
ORA-01000: maximum open cursors exceeded
. . exporting table X_AREA_NAME202_TAB
EXP-00056: ORACLE error 1000 encountered
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |