expdp:ORA-31634: job already exists
来源:互联网 发布:java迷宫最短路径算法 编辑:程序博客网 时间:2024/05/28 20:19
测试通过:expdp:ORA-31634: job already exists
问题描述:
使用数据泵进行全备,由于user的表空间不足导致备份失败,添加user表空间,清理空间后再次进行备份报如下错误:
With the Partitioning, OLAP and Data Mining options
ORA-31634: job already exists
ORA-31664: unable to construct unique job name when defaulted
58ffe4c9565ba721a4ca690a17de84d34a9bf6ecdc6a4a9e0443b14d0cf38268
5814b8610909e5849b8f1a93736a2b1df94d98dc8d9985a62061cc1ab3bb6384
解决方法:
1. 在备份时指定一个在dba_datapump_jobs中没有不存在的一个job_name
2. 清理dba_datapump_jobs表
1)查询可以清理的master table并生成SQL
select 'drop table ' || owner_name || '.' || job_name || ';'
from dba_datapump_jobs
where state = 'NOT RUNNING'
2)清理后再次dba_datapump_jobs确认清理成功
SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2;
若不成功,按下面的方法再次清理
sqlplus oak/oak
exec dbms_datapump.stop_job(dbms_datapump_attach(‘SYS_EXPORT_TABLE_01’,’OAK’));
3、如果还不行,就用下面的方法:
select 'drop table system.sys_export_schema_'||lpad(level,2,'0')||';' from dual connect by level<=99;
该语句会生成一些sql语句,直接粘贴这些新生成的语句就可以了。
- expdp:ORA-31634: job already exists
- ORA-31634: job already exists
- ORA-31634: job already exists
- EXPDP导出报错job already exists
- oracle impdp导入数据出错,ORA-31634: job already exists
- ORA-20211: Active job record exists问题解决
- ORA-27100:shared memory realm already exists
- ORA-27100: shared memory realm already exists
- ORA-27100 shared memory realm already exists
- expdp ORA-31626: job does not exist 解决方案
- expdp ORA-31626: job does not exist 解决方案
- 如何解决ORA-27100 shared memory realm already exists错误
- startup nomount ORA-27100: shared memory realm already exists
- ORA-27100:shared memory realm already exists 解决方法
- 解决ORA--27100 shared memory realm already exists报错
- 10G 重建EM 报ORA-20001: SYSMAN already exists
- ora-27100:shared memory realm already exists错误的解决
- Oracle10g重建EM 报ORA-20001: SYSMAN already exists
- Connections could not be acquired from the underlying database!
- [教程]隐藏ActionBar中的MenuItem
- LNK2005: __thiscall type_info::type_info(class type_info const &) already defined in LIBCMTD.lib
- JBoss下数据库连接的密码加密
- SQLServer函数
- expdp:ORA-31634: job already exists
- CentOS下以RPM方式安装MySQL5.5
- Android 设备上实现串口的移植
- Android 像桌面左右滑动功能实现
- GDB常用命令简介[zz]
- Win7 vs2010+Silverlight4开发安装顺序
- jQuery跟Extjs的区别
- C#中绘图时遇到滚动条问题
- MYSQL IFNULL函数的使用