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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29798713/viewspace-1295841/