Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Strange import errors

RE: Strange import errors

From: Jack van Zanen <nlzanen1_at_ey.nl>
Date: Fri, 14 Jul 2000 13:28:10 +0100
Message-Id: <10558.112046@fatcity.com> 





Hi,




This solved indeed the the error messages but than I got different ones



***************************New errors***************





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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table                  "DEF$_AQCALL"          0 rows imported


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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table                 "DEF$_AQERROR"          0 rows imported


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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table                "DEF$_CALLDEST"          0 rows imported


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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table             "DEF$_DEFAULTDEST"          0 rows imported


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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table             "DEF$_DESTINATION"          1 rows imported


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


 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"


 " AIX/RS600 4.1-8.0.0'); END;"



IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
. . importing table                   "DEF$_ERROR"          0 rows imported
. . importing table                     "DEF$_LOB"          0 rows imported
. . importing table                  "DEF$_ORIGIN"          0 rows imported
. . importing table              "DEF$_PROPAGATOR"          0 rows imported
. . importing table                "DEF$_TEMP$LOB"          0 rows imported
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. . importing table      "REPCAT$_AUDIT_ATTRIBUTE"
IMP-00019: row rejected due to ORACLE error 1


IMP-00003: ORACLE error 1 encountered


ORA-00001: unique constraint (SYSTEM.REPCAT$_AUDIT_ATTRIBUTE_PK) violated
Column 1 TIMESTAMP


Column 2 3


Column 3


Column 4 SYSDATE

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_AUDIT_ATTRIBUTE_PK) violated


Column 1 GLOBAL NAME


Column 2 2


Column 3 128


Column 4 DBMS_REPUTIL.GLOBAL_NAME          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_AUDIT_ATTRIBUTE" ADD  CONSTRAINT "REPCAT$_AUDIT_ATTRIB"


 "UTE_C1" CHECK ((data_type_id in (2, 4, 5, 6, 7) and                   data_"

 "length is not null)               or (data_type_id not in (2, 4, 5, 6, 7) a"

 "nd                   data_length is null)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

. . importing table         "REPCAT$_AUDIT_COLUMN"          0 rows imported
. . importing table         "REPCAT$_COLUMN_GROUP"          0 rows imported
. . importing table             "REPCAT$_CONFLICT"          0 rows imported


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


 "ALTER TABLE "REPCAT$_CONFLICT" ADD  CONSTRAINT "REPCAT$_CONFLICT_C1" CHECK "


 "(conflict_type_id in (1, 2, 3)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

. . importing table                  "REPCAT$_DDL"          0 rows imported
. . importing table            "REPCAT$_GENERATED"          0 rows imported


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


 "ALTER TABLE "REPCAT$_GENERATED" ADD  CONSTRAINT "REPCAT$_GENERATED_OBJ" CHE"


 "CK (reason IN (0, 1, 2, 3, 4, 5, 6, 7, 9, 10)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

. . importing table       "REPCAT$_GROUPED_COLUMN"          0 rows imported
. . importing table          "REPCAT$_KEY_COLUMNS"          0 rows imported
. . importing table     "REPCAT$_PARAMETER_COLUMN"          0 rows imported
. . importing table             "REPCAT$_PRIORITY"          0 rows imported
. . importing table       "REPCAT$_PRIORITY_GROUP"          0 rows imported


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


 "ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD  CONSTRAINT "REPCAT$_PRIORITY_GROU"


 "P_C1" CHECK (data_type_id in (1, 2, 3, 4, 5, 6, 7)) ENABLE NOVALIDATE"


IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2261:


 "ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD  CONSTRAINT "REPCAT$_PRIORITY_GROU"

 "P_U1" UNIQUE ("SNAME","PRIORITY_GROUP","DATA_TYPE_ID","FIXED_DATA_LENGTH") "



 "USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 16384 NEXT "


 "16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP"


 "S 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" ENABLE NOVALIDATE"



IMP-00003: ORACLE error 2261 encountered
ORA-02261: such unique or primary key already exists in the table
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD  CONSTRAINT "REPCAT$_PRIORITY_GROU"

 "P_C2" CHECK ((data_type_id in (4, 7) and                   fixed_data_lengt"

 "h is not null)               or (data_type_id in (1, 2, 3, 5, 6) and       "

 "            fixed_data_length is null)) ENABLE NOVALIDATE"



IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table               "REPCAT$_REPCAT"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_REPCAT" ADD  CONSTRAINT "REPCAT$_REPCAT_STATUS" CHECK "


 "(status IN (0, 1, 2)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table            "REPCAT$_REPCATLOG"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_REPCATLOG" ADD  CONSTRAINT "REPCAT$_REPCATLOG_REQUEST""


 " CHECK (request IN (-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,                  "

 "                      11, 12)) ENABLE NOVALIDATE"



IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:




 "ALTER TABLE "REPCAT$_REPCATLOG" ADD  CONSTRAINT "REPCAT$_REPCATLOG_TYPE" CH"


 "ECK (type IN (-1, 0, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3)) ENABLE NOVALIDATE"


IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:




 "ALTER TABLE "REPCAT$_REPCATLOG" ADD  CONSTRAINT "REPCAT$_REPCATLOG_STATUS" "


 "CHECK (status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table            "REPCAT$_REPCOLUMN"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2261:


 "ALTER TABLE "REPCAT$_REPCOLUMN" ADD  CONSTRAINT "REPCAT$_REPCOLUMN_UK" UNIQ"


 "UE ("SNAME","ONAME","TYPE","POS") USING INDEX PCTFREE 10 INITRANS 2 MAXTRAN"


 "S 255 STORAGE (INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCR"


 "EASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYST"


 "EM" ENABLE NOVALIDATE"




IMP-00003: ORACLE error 2261 encountered
ORA-02261: such unique or primary key already exists in the table
. . importing table            "REPCAT$_REPOBJECT"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_REPOBJECT" ADD  CONSTRAINT "REPCAT$_REPOBJECT_TYPE" CH"


 "ECK (type IN (-1, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3)) ENABLE NOVALIDATE"


IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:




 "ALTER TABLE "REPCAT$_REPOBJECT" ADD  CONSTRAINT "REPCAT$_REPOBJECT_STATUS" "


 "CHECK (status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE"


IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:




 "ALTER TABLE "REPCAT$_REPOBJECT" ADD  CONSTRAINT "REPCAT$_REPOBJECT_GENPACKA"


 "GE" CHECK (genpackage IN (0, 1, 2)) ENABLE NOVALIDATE"


IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with ORACLE error 2264:




 "ALTER TABLE "REPCAT$_REPOBJECT" ADD  CONSTRAINT "REPCAT$_REPOBJECT_GENTRIGG"


 "ER" CHECK (gentrigger IN (0, 1, 2)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . importing table              "REPCAT$_REPPROP"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:


 "ALTER TABLE "REPCAT$_REPPROP" ADD  CONSTRAINT "REPCAT$_REPPROP_HOW" CHECK ("


 "how IN (0, 1, 2, 3)) ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

. . importing table            "REPCAT$_REPSCHEMA"          0 rows imported
. . importing table           "REPCAT$_RESOLUTION"          0 rows imported
. . importing table    "REPCAT$_RESOLUTION_METHOD"
IMP-00019: row rejected due to ORACLE error 1


IMP-00003: ORACLE error 1 encountered


ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 1


Column 2 MINIMUM

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 EARLIEST TIMESTAMP

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 MAXIMUM

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 LATEST TIMESTAMP

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 SITE PRIORITY

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 PRIORITY GROUP

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 ADDITIVE

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 AVERAGE

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 OVERWRITE

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 DISCARD

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 1


Column 2 USER FUNCTION

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 2


Column 2 APPEND SITE NAME

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 2


Column 2 APPEND SEQUENCE

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 2


Column 2 DISCARD

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated


Column 1 2


Column 2 USER FUNCTION

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violated
Column 1 3
Column 2 USER FUNCTION          0 rows imported


********************************





Do you happen to know these as well??





TIA



jack






"Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com>@fatcity.com on 07/14/2000
11:36:22 AM



Please respond to ORACLE-L_at_fatcity.com



Sent by:  root_at_fatcity.com




To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:


Subject:  RE: Strange import errors




Jack




 You must run catrep.sql if you are importing an export file which has
 replication objects in it.



 This script needs to be run as SYS or INTERNAL.



 Catrep.sql runs prvtdefr.plb which creates the necessary package related to



 QUEUE_IMPORT_CHECK.


 After catrep.sql is successfully run, you should be able to run import
without


 getting errors indicated in the problem section.



HTH



Rick

> -----Original Message-----
> From:   Jack van Zanen [SMTP:nlzanen1_at_ey.nl]
> Sent:   Friday, July 14, 2000 5:27 AM
> To:     Multiple recipients of list ORACLE-L
> Subject:     Strange import errors
>
>
>
>
> Hi All,
>
>
> I'm on the phone with OWW support  at the moment and can't get the answer
> right
> now so maybe you guys know what the problem is here
>
>
> *******Import Error*********8
>
>
> IMP-00017: following statement failed with ORACLE error 6550:
>  "BEGIN
> SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('PPRD.WORLD','IBM"
>  " AIX/RS600 4.1-8.0.0'); END;"
> IMP-00003: ORACLE error 6550 encountered
> ORA-06550: line 1, column 40:
> PLS-00302: component 'QUEUE_IMPORT_CHECK' must be declared
> ORA-06550: line 1, column 9:
> PL/SQL: Statement ignored
> . . importing table                  "DEF$_AQCALL"          0 rows
> imported
>
>
> **************************
>
> We  can't even find which script is supposed to create the package
> involved.
>
> Catalog , catproc, catexp don't create it
>
> Any Ideas here
>
> Oracle 8.0.5
> AIX 4.3.3
> both target and source database are same specs/versions
>
> Full export & full import
>
>
> TIA
>
>
>
> Jack
>
>
> ===================================================================
> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
> de geadresseerde. Gebruik van deze informatie door anderen dan de
> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
> en/of verstrekking van deze informatie aan derden is niet toegestaan.
> Ernst & Young staat niet in voor de juiste en volledige overbrenging van
> de
> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ===================================================================
> The information contained in this communication is confidential and may be
> legally privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed and others authorised to receive it. If you
> are not the intended recipient you are hereby notified that any
> disclosure,
> copying,  distribution or taking any action in reliance on the contents of
> this information is strictly prohibited and may be unlawful. Ernst &
> Young is neither liable  for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt.
> ===================================================================
>
>
>
> --
> Author: Jack van Zanen
>   INET: nlzanen1_at_ey.nl
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).




--
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





===================================================================
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===================================================================
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,


Received on Fri Jul 14 2000 - 07:28:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US