利用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