When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, ORA-01031, ORA-06512. Possible errors may be as follows.
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp(‘ORCL1′,0,1,’10.02.00.05.00’,newblock)
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_SESSION”, line 97
ORA-06512: at “WMSYS.LT_CTX_PKG”, line 2116
ORA-06512: at “WMSYS.LT_EXPORT_PKG”, line 1545
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_SESSION”, line 97
ORA-06512: at “WMSYS.LT_CTX_PKG”, line 2116
ORA-06512: at “WMSYS.LT_EXPORT_PKG”, line 1545
ORA-06512: at line 1
ORA-06512: at “SYS.DB
These errors relate to context object named LT_CTX. In some cases, expdp authorization error occurs when this context is created by using SYS.LT_CTX_PKG. The Context object must be created using WMSYS.LT_CTX_PKG.
These errors will not appear when you drop and recreate the existing object.
Run With SYS:
1 2 | SQL> DROP CONTEXT LT_CTX; SQL> CREATE OR REPLACE CONTEXT LT_CTX USING WMSYS.LT_CTX_PKG; |