Impdp Expdp Failed with ORA-31626, ORA-31633, ORA-06512, ORA-01031

Error description

Oracle data pump expdp / impdp failed with following errors.

Import: Release - Production on Fri Jun 20 07:42:33 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: scott

Connected to: Oracle Database 11g Release - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "SCOTT.SYS_IMPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-01031: insufficient privileges

Solution Description
If you are trying for export using expdp you have to give EXP_FULL_DATABASE privilege to the user which you are using for the export.

Or if you are trying to import using impdp, you will have to give IMP_FULL_DATABASE privilege to the user which you are using for the export. Also you have to give required space quota to the user.

SQL> grant IMP_FULL_DATABASE to scott;

Grant succeeded.
SQL> alter user scott quota unlimited on users;
User altered.

SQL> grant EXP_FULL_DATABASE to scott;

Grant succeeded.
DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google