2.) 确认这些object对应的导出文件都已经创建
到之前创建的directory 即awdir对应的 /nasdir/dmpdir3 上查看文件已生成, 目录名称查询:
SELECT * FROM ALL_DIRECTORIES WHERE DIRECTORY_NAME like '%AWDIR%';
如果没有文件在这个目录下产生,那么请不要继续执行下面的步骤了。
3.) 通过如下命令rename current AW (如果是在另外一个目标库生成,那么这一步省略).
connect apps/wei1234$
exec dbms_aw.aw_rename('apps.odpcode', 'apps.odpcode_orig');
commit;
connect zpb/wei1234$
exec dbms_aw.aw_rename('zpb.zpbcode', 'zpb.zpbcode_orig');
commit;
4.) 确认apps用户的默认表空间是 APPS_TS_TX_DATA :
select DEFAULT_TABLESPACE from dba_users where username = 'APPS';
5.) 在目标库上重建这些objects,注意目标库要能访问到eif文件,可以建一个awdir
目录,将eif文件拷贝到这里 (这里是NAS共享的目录).
grant create any directory to system;
create directory awdir as '/nasdir/dmpdir3';
grant read,write on directory awdir to system ;
以apps用户登录sqlplus :
exec dbms_aw.execute('aw create apps.odpcode');
exec dbms_aw.execute('import all from eif file ''awdir/odpcode.eif''');
exec dbms_aw.execute('update');
exec dbms_aw.execute('listnames'); # compare with results from step 1
exec dbms_aw.execute('aw detach apps.odpcode');
commit;
exec dbms_aw.execute('aw create zpb.zpbcode');
exec dbms_aw.execute('import all from eif file ''awdir/zpbcode.eif''');
exec dbms_aw.execute('update');
exec dbms_aw.execute('listnames'); # compare with results from step 1
exec dbms_aw.execute('aw detach zpb.zpbcode');
commit;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1215905/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1215905/