Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1038953
  • 博文数量: 74
  • 博客积分: 10000
  • 博客等级: 上将
  • 技术积分: 2950
  • 用 户 组: 普通用户
  • 注册时间: 2007-05-15 00:17
文章分类

全部博文(74)

文章存档

2009年(1)

2008年(73)

我的朋友

分类: 服务器与存储

2008-06-29 23:22:18

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;
阅读(1901) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~