exp/imp(9)之导入

imp全库导入是最烦人的一步,它会有很多错误,而你要做的就是从日志中找到错误,分析原因,一个一个的减少

 

如果是生产库,建议使用用户级导入,实在没办法则请充分测试.

 

 

impdp system/open1sys DUMPFILE=df1.dmp DIRECTORY=expdir FULL=y LOGFILE=impdp1.log

if the following error happened,please check dump directory and authority
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

*************************************
1:Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2702 error(s) at 06:05:42
*************************************

ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
BEGIN DBMS_JOB.ISUBMIT( JOB=> 1, NEXT_DATE=> TO_DATE('2008-06-29 02:45:26', 'YY
YY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 1 / (24 * 60)', WHAT=> 'EMD_MAI
NTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();', NO_PARSE=> TRUE); END;

 

SQL> exec sys.dbms_ijob.remove(1)
SQL> COMMIT;

*************************************
2:Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2025 error(s) at 07:51:31
*************************************
DROP USER ANONYMOUS CASCADE;
DROP USER OUTLN CASCADE;
DROP USER WMSYS CASCADE;
DROP USER ORDSYS CASCADE;
DROP USER ORDPLUGINS CASCADE;
DROP USER MDSYS CASCADE;
DROP USER CTXSYS CASCADE;
DROP USER XDB CASCADE;
DROP USER WKSYS CASCADE;
DROP USER WKPROXY CASCADE;
DROP USER ODM CASCADE;
DROP USER ODM_MTR CASCADE;
DROP USER OLAPSYS CASCADE;
DROP USER HR CASCADE;
DROP USER OE CASCADE;
DROP USER PM CASCADE;
DROP USER SH CASCADE;
DROP USER QS_ADM CASCADE;
DROP USER QS CASCADE;
DROP USER QS_WS CASCADE;
DROP USER QS_ES CASCADE;
DROP USER QS_OS CASCADE;
DROP USER QS_CBADM CASCADE;
DROP USER QS_CB CASCADE;
DROP USER QS_CS CASCADE;