创建ORACLE数据中心提示报错-作业已存在
4,015次浏览
编辑于2014年09月16日 15:24:53
创建oracle数据中心时提示这个错误!
ORA-31634: 作业已存在
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: 在 "SYS.DBMS_DATAPUMP", line 1137
ORA-06512: 在 "SYS.DBMS_DATAPUMP", line 5283
ORA-06512: 在 line 5|declare
h1 NUMBER;
l1 varchar2(20);
begin
h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', job_name => 'JOB_EXP2', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'OracleBCPatternDB.log', directory => 'DATA_PUMP_DIR', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.add_file(handle => h1, filename => 'OracleBCPatternDB.dmp', directory => 'DATA_PUMP_DIR', filetype => 1);
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''KDSA'')');
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'KDSA', value => 'YAMAEASNEW');
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_TABLESPACE', old_value => 'USERS', value => 'YAMAEASNEW');
dbms_datapump.metadata_transform(handle => h1, name => 'OID', value => 0);
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.wait_for_job(handle => h1, job_state => l1);
dbms_datapump.detach(handle => h1);
end;
另外,
https://vip.kingdee.com/article/285117971175956235创建oracle数据中心 我已经按照这个帖子把对应dmp拷贝过去了,创建数据中心仍然报以上错误信息。
请大侠指点,谢谢!
推荐阅读