第一个问题:
"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 的工作号在整个数据库中 唯一
第三个问题:
未解决
[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.
出错原因: 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/