【Troubleshooting】ORA-31626 job does not exist and ORA-31633 unable to create master table when executing EXPDP

数据库平台:Linux 5.8 数据库版本:oracle 11.2.0.1 【问题描述】 使用脚本进行expdp导出,报错如下: [cce_oracle11] ORA-31626: job does not exist ORA-31633: unable to create master table "ULTRANMS.EXPDP_ULTRANMS" 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 [/cce_oracle11] 截图如下: 【处理方法】 ORA-31626,ORA-31633的报错中明确指出了问题所在。首先是job不存在,其次无法创建expdp_ultranms表,最后说明对象已经存在。 查看执行的脚本内容: [cce_bash] [oracle@IT-DB ]cat NMSDB_backup.sh LANG=C export LANG ORACLE_SID=citinms export ORACLE_SID NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export NLS_LANG umask 022 DATE=`date +%Y%m%d` #find /oradatabak -name "nmsdbbak_*.dmp" -type f -mtime +1 -exec rm {} \; #find /oradatabak -name "nmsdbbak_*.log" -type f -mtime +1 -exec rm {} \; #find /oradatabak -name … [Read more...]