Friday , November 22 2024

Data Pump, expdp ORA-39127, ORA-01031, ORA-06512 Errors

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:

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *