|
-
I am supposed to do migration for this database from 9i to 10g and the
application team did't specify anything about replication or anything
just gave access to source and expected me to do it,so anyway
1)i exported full but started getting errors ORA-12899 while importing for table T_CUSTOMER so imported everything then i truncated the table T_CUSTOMER and increased the width of the column to 150(orignal 80)
but it was giving error ORA-00001 while loading this table so as suggested
pre-created table with no PK and loaded data then i thought of deleting
any duplicate data but it gave error ORA-23474 then i dropped the idea of deleting the duplicate rows and started enabling the constraints and got the
following errors
IMP-00017: following statement failed with ORACLE error 23313:
"BEGIN SYS.DBMS_REPCAT.REPCAT_IMPORT_REPSCHEMA; END;"
IMP-00003: ORACLE error 23313 encountered
ORA-23313: object group "PUBLIC"."EXTERNAL" is not mastered at GLISD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT", line 1065
ORA-06512: at line 1
. importing GLISADM's objects into GLISADM
. importing SYSTEM's objects into SYSTEM
. importing GLISADM's objects into GLISADM
. importing REPDBA's objects into REPDBA
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "REPCAT$_GENERATED" ENABLE CONSTRAINT "REPCAT$_REPGEN_PRNT""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (SYSTEM.REPCAT$_REPGEN_PRNT) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "REPCAT$_GENERATED" ENABLE CONSTRAINT "REPCAT$_REPGEN_PRNT2""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (SYSTEM.REPCAT$_REPGEN_PRNT2) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "REPCAT$_REPCOLUMN" ENABLE CONSTRAINT "REPCAT$_REPCOLUMN_FK""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (SYSTEM.REPCAT$_REPCOLUMN_FK) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "REPCAT$_REPPROP" ENABLE CONSTRAINT "REPCAT$_REPPROP_PRNT""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (SYSTEM.REPCAT$_REPPROP_PRNT) - parent keys not found
. importing GLISADM's objects into GLISADM
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_APL" ENABLE CONSTRAINT "C_APL_FK_01""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_APL_FK_01) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_APL" ENABLE CONSTRAINT "C_APL_FK_02""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_APL_FK_02) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_APL" ENABLE CONSTRAINT "C_APL_FK_02""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_APL_FK_02) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_APL" ENABLE CONSTRAINT "C_APL_FK_CB""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_APL_FK_CB) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_01""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_01) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_02""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_02) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_04""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_04) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_05""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_05) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_06""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_06) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_07""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_07) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_CB""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_CB) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CALL" ENABLE CONSTRAINT "C_CAL_FK_MB""
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (GLISADM.C_CAL_FK_MB) - parent keys not found
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "T_CDPART" ENABLE CONSTRAINT "C_CDP_FK_CB""
hope i made things clearer this time .
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|