oracle imp无效,oracle imp 导入遇到问题,两个已解决，还有一个没有解决

第一个问题："CREATE TYPE "ENAMET" TIMESTAMP '2014-04-27:22:57:34' OID 'F8086B3B31C1FF51E"

出错原因： type 类型的 段，其 OID 值在整个数据库中 唯一

第二个问题：   "BEGIN   DBMS_JOB.ISUBMIT(JOB=>24,WHAT=>'update emppr set deptno=deptno+1;',"

出错原因：  JOB 的工作号在整个数据库中 唯一

第三个问题：

IMP-00003: ORACLE error 14063 encountered

ORA-14063: Unusable index exists on unique/primary constraint key

IMP-00017: following statement failed with ORACLE error 14048:

"ALTER INDEX "PK_EMPPR"UNUSABLE ENABLE "

IMP-00003: ORACLE error 14048 encountered

ORA-14048: a partition maintenance operation may not be combined with other operations

原因：  pk_emppr 索引 为 unusable enable ，alter index pk_emppr rebuild; 重建后，在导出，导入即可

第四个问题：Note: table contains ROWID column, values may be obsolete          6 rows imported

未解决

[oracle@rhel5-8-1 bk]$ imp system/oracle file=/bk/expscott.bak fromuser=scott touser=u1 ignore=y;

Import: Release 11.2.0.1.0 - Production on Sun Oct 12 00:01:15 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set

. importing SCOTT's objects into U1

IMP-00017: following statement failed with ORACLE error 2304:

"CREATE TYPE "ENAMET" TIMESTAMP '2014-04-27:22:57:34' OID 'F8086B3B31C1FF51E"

"040A8C00A012B8D'   as object(name varchar2(10),sex varchar2(2));"

IMP-00003: ORACLE error 2304 encountered

ORA-02304: invalid object identifier literal

. . importing table                          "DEP"          4 rows imported

. . importing table                         "DEPT"          4 rows imported

. . importing table                           "E4"          0 rows imported

. . importing table                           "EM"         14 rows imported

. . importing table                          "EMP"         14 rows imported

. . importing table                         "EMP1"          0 rows imported

. . importing partition             "EMPPR":"EMPPR_P1"          1 rows imported

. . importing partition             "EMPPR":"EMPPR_P2"         10 rows imported

. . importing partition             "EMPPR":"EMPPR_P3"          1 rows imported

. . importing partition             "EMPPR":"EMPPR_P4"          0 rows imported

IMP-00017: following statement failed with ORACLE error 14063:

"ALTER TABLE "EMPPR" ADD  CONSTRAINT "PK_EMPPR" PRIMARY KEY ("EMPNO") USING "

"INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576"

" MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE"

" "USERS" LOGGING"

IMP-00003: ORACLE error 14063 encountered

ORA-14063: Unusable index exists on unique/primary constraint key

IMP-00017: following statement failed with ORACLE error 14048:

"ALTER INDEX "PK_EMPPR" UNUSABLE ENABLE "

IMP-00003: ORACLE error 14048 encountered

ORA-14048: a partition maintenance operation may not be combined with other operations

. . importing table                   "EXCEPTIONS"

Note: table contains ROWID column, values may be obsolete          6 rows imported

. . importing table                         "SALG"          5 rows imported

. . importing table                     "SALGRADE"          5 rows imported

. . importing table                           "T1"          8 rows imported

. . importing table                           "T2"         11 rows imported

. . importing table                           "T3"      32768 rows imported

. . importing table                           "T4"     917504 rows imported

. . importing table                           "T5"          0 rows imported

. . importing table                           "T6"          0 rows imported

. . importing table                           "TC"          1 rows imported

IMP-00017: following statement failed with ORACLE error 1:

"BEGIN   DBMS_JOB.ISUBMIT(JOB=>23,WHAT=>'update emppr set sal=sal+1;',NEXT_D"

"ATE=>TO_DATE('2014-10-10:23:48:01','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'sysd"

"ate+1/24/60',NO_PARSE=>TRUE); END;"

IMP-00003: ORACLE error 1 encountered

ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

ORA-06512: at "SYS.DBMS_JOB", line 100

ORA-06512: at line 1

IMP-00017: following statement failed with ORACLE error 1:

"BEGIN   DBMS_JOB.ISUBMIT(JOB=>24,WHAT=>'update emppr set deptno=deptno+1;',"

"NEXT_DATE=>TO_DATE('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL="

">'sysdate+1/24/60',NO_PARSE=>TRUE); END;"

IMP-00003: ORACLE error 1 encountered

ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

ORA-06512: at "SYS.DBMS_JOB", line 100

ORA-06512: at line 1

About to enable constraints...

Import terminated successfully with warnings.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29798713/viewspace-1295841/，如需转载，请注明出处，否则将追究法律责任。