ORA-31633: unable to create master table "NEW.GWJOB"

利用impdp导入文件的时候，报错：

ORA-31626: job does not exist
ORA-31633: unable to create master table "NEW.GWJOB"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-00955: name is already used by an existing object

查看错误信息：

$ oerr ora 31633
31633, 00000, "unable to create master table \"%s.%s\""
// *Cause:  Job creation failed because a Master Table and its indexes could
//          not be created, most commonly due to the pre-existance of a table
//          with the same name (job name) in the user schema.  Refer to any
//          following error messages for clarification.
// *Action: Select a different job name, DROP the existing table, or eliminate
//          any problems indicated by the following error messages.

你给job改个名字是可以的，另外一种方法就是手工删除gwjob这个表，因为如果正常执行impdp导入完成后会自动删除，如果执行过程

出了故障，意外退出了，则不能删除表，下次导入，就会报这个错误。

如需转载，请注明出处：http://blog.csdn.net/nanaranran/article/details/25639847