Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will talk about Data Pump Jobs ORA-31626,ORA-31633,ORA-06512 Errors.
Sometimes Oracle DB can cause us problems while exporting.
If you are getting the error as below, follow.
Error message
1 2 3 4 5 6 7 8 | Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options ORA-31626: job does not exist ORA-31633: unable to create master table “SYS_EXPORT_SCHEMAS_01” ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95 ORA-06512: at “SYS.KUPV$FT”, line 863 ORA-00955: name is already used by an existing object |
Answer
1 2 3 4 5 6 | SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs; OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ---------- -------------------- ---------- ---------- ------------ SYS SYS_EXPORT_SCHEMAS_01 EXPORT FULL NOTRUNNIG SQL> drop table SYS.SYS_EXPORT_SCHEMAS_01; Table dropped. |
After the table is dropped, you can easily continue the process.
