Database Utilities (MOSC)

MOSC Banner

EXPDP fails with ORA-31626 ORA-31637 ORA-39244 ORA-01031

edited Aug 7, 2017 3:50PM in Database Utilities (MOSC) 17 commentsAnswered ✓

Hi guys, I am trying to do a metadata export, but it fails with these errors:

$ORACLE_HOME/bin/expdp userid=C##USR_EXPORT/****@PDB full=y content=METADATA_ONLY directory=EXPORT_METADATA dumpfile=example.dmp logfile=example.log
Export: Release 12.1.0.2.0 - Production on Tue May 9 11:10:04 2017Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsORA-31626: job does not existORA-31637: cannot create job SYS_EXPORT_FULL_01 for user C##USR_EXPORTORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPV$FT_INT", line 810ORA-39244: Event to disable dropping null bit image header during relational selectORA-06512: at "SYS.DBMS_SYS_ERROR", line 86ORA-06512: at "SYS.KUPC$QUE_INT", line 1898ORA-01031: insufficient privileges

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center