Home » RDBMS Server » Server Utilities » Upgrade 8i to 10g (windows 2003)
Upgrade 8i to 10g [message #480806] Wed, 27 October 2010 06:16 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
dear all,

i was created this same thread in Dba-village. i need to attache my log file so i came here experts please help me.

i want to upgrade my database 8i to 10g, for testing purpose
i install 10g with started database and i created needed users
and i import using dump

imp system/passwd file=dumpfile.dmp log=logfile.log rows=y ignore=y statistics=none full=y

the log file gave some errors and warnings i will attach my log file, coould you please tell me what action i need to proceed

thanks
  • Attachment: imparmada.log
    (Size: 1.14MB, Downloaded 1509 times)
Re: Upgrade 8i to 10g [message #480810 is a reply to message #480806] Wed, 27 October 2010 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many of us can't or don't want to download files, so post them inline and post them formatted.
Post ONLY the relevant part NOT the whole file.

Quote:
i was created this same thread in Dba-village

And why don't you post a link to it for us to know at which point you are?

Regards
Michel
Re: Upgrade 8i to 10g [message #480813 is a reply to message #480810] Wed, 27 October 2010 06:52 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "RBS" DATAFILE  'C:\ORACLE\ORADATA\ARMADA\RBS01.DBF' SIZE"
 " 545259520       AUTOEXTEND ON NEXT 5242880  MAXSIZE 32767M DEFAULT  STORAG"
 "E(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50) O"
 "NLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'C:\ORACLE\ORADATA\ARMADA\RBS01.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 12913:
 "CREATE TABLESPACE "TEMP" DATAFILE  'C:\ORACLE\ORADATA\ARMADA\TEMP01.DBF' SI"
 "ZE 136314880       AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M DEFAULT  STORA"
 "GE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE "
 "0) ONLINE TEMPORARY "
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 3249:
 "CREATE TABLESPACE "TOOLS" DATAFILE  'C:\ORACLE\ORADATA\ARMADA\TOOLS01.DBF' "
 "SIZE 12582912       AUTOEXTEND ON NEXT 327680  MAXSIZE 32767M DEFAULT  STOR"
 "AGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ON"
 "LINE PERMANENT "
IMP-00003: ORACLE error 3249 encountered
ORA-03249: Uniform size for auto segment space managed tablespace should have atleast 5 blocks
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "INDX" DATAFILE  'C:\ORACLE\ORADATA\ARMADA\INDX01.DBF' SI"
 "ZE 60817408       AUTOEXTEND ON NEXT 1310720  MAXSIZE 32767M DEFAULT  STORA"
 "GE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) O"
 "NLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'C:\ORACLE\ORADATA\ARMADA\INDX01.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
 "CREATE TABLESPACE "DRSYS" DATAFILE  'C:\ORACLE\ORADATA\ARMADA\DR01.DBF' SIZ"
 "E 92274688       AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M DEFAULT  STORAGE"
 "(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50"
 ") ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'C:\ORACLE\ORADATA\ARMADA\DR01.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 959:
 "ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' DEFAULT TABLESP"
 "ACE "TOOLS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. importing OSE$HTTP$ADMIN's objects into OSE$HTTP$ADMIN
. importing HONDAPROD's objects into HONDAPROD
. importing TEST's objects into TEST
. importing TRAINING's objects into TRAINING
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 23327:
 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ARMADA','IBMPC/W"
 "IN_NT-8.1.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
IMP-00017: following statement failed with ORACLE error 23327:
 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ARMADA','IBMPC/W"
 "IN_NT-8.1.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"          0 rows imported
IMP-00017: following statement failed with ORACLE error 23327:
 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ARMADA','IBMPC/W"
 "IN_NT-8.1.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('ARMADA','IBMPC/W"
 "IN_NT-8.1.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
. . importing table                     "DEF$_LOB"          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              "DEF$_PROPAGATOR"          0 rows imported
. . importing table                  "DEF$_ORIGIN"          0 rows imported
. . importing table     "DEF$_PUSHED_TRANSACTIONS"          0 rows imported
. . 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$_FLAVORS"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
 "ALTER TABLE "REPCAT$_FLAVORS" ADD CONSTRAINT "REPCAT$_FLAVORS_C2" CHECK (pu"
 "blished is NULL or (published in ('Y','N','O'))) 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$_SNAPGROUP"          0 rows imported
. . 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" CHE"
 "CK (type IN (-1, 1, 2, 4, 5, 7, 8, 9, 11, 12, -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_STATUS" C"
 "HECK (status IN (0, 1, 2, 3, 4, 5)) 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_GENPACKAG"
 "E" 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_GENTRIGGE"
 "R" 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$_REPCOLUMN"          0 rows imported
. . importing table          "REPCAT$_KEY_COLUMNS"          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" CHEC"
 "K (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$_REPPROP"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
 "ALTER TABLE "REPCAT$_REPPROP" ADD CONSTRAINT "REPCAT$_REPPROP_HOW" CHECK (h"
 "ow 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$_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, 13, 14, 15)) ENABLE NOVALIDA"
 "TE"
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" CHE"
 "CK (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" C"
 "HECK (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$_DDL"          0 rows imported
. . importing table       "REPCAT$_REPGROUP_PRIVS"          0 rows imported
IMP-00017: following statement failed with ORACLE error 2264:
 "ALTER TABLE "REPCAT$_REPGROUP_PRIVS" ADD  CONSTRAINT "REPCAT$_REPGROUP_PRIV"
 "S_UK" UNIQUE ("USERID", "GNAME", "GOWNER") USING INDEX PCTFREE 10 INITRANS "
 "2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 214"
 "7483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) T"
 "ABLESPACE "SYSTEM" ENABLE "
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
. . 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_GROUP"
 "_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 2264:
 "ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD CONSTRAINT "REPCAT$_PRIORITY_GROUP"
 "_C2" CHECK ((data_type_id in (4, 7) and"
 "                  fixed_data_length 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$_PRIORITY"          0 rows imported
. . importing table         "REPCAT$_COLUMN_GROUP"          0 rows imported
. . importing table       "REPCAT$_GROUPED_COLUMN"          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$_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 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 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 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 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 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 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 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 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 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 USER FLAVOR 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 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 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 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 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 FLAVOR 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 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 FLAVOR 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
. . importing table           "REPCAT$_RESOLUTION"          0 rows imported
. . importing table "REPCAT$_RESOLUTION_STATISTICS"          0 rows imported
. . importing table  "REPCAT$_RESOL_STATS_CONTROL"          0 rows imported
. . importing table     "REPCAT$_PARAMETER_COLUMN"          0 rows imported
. . 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_ATTRIBU"
 "TE_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) and"
 "                  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$_FLAVOR_OBJECTS"          0 rows imported
. . importing table                         "HELP"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 1
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 2
Column 3  @ ("at" sign)
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 3
Column 3  -------------
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 4
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 5
Column 3  Runs the specified command file.
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 6
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 7
Column 3  @ file_name[.ext] [arg...]
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @
Column 2 8
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 1
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 2
Column 3  @@ (double "at" sign)
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 3
Column 3  ---------------------
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 4
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 5
Column 3  Runs the specified command file. This command is ...
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 6
Column 3  command except that it looks for the specified co...
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 7
Column 3  same path as the command file from which it was c...
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 8
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 9
Column 3  @@ file_name[.ext]
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 @@
Column 2 10
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 1
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 2
Column 3  / (slash)
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 3
Column 3  ---------
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 4
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 5
Column 3  Executes a SQL command or PL/SQL block in the SQL...
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 6
Column 3  slash (/) at the command prompt or at a line numb...
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 7
Column 3 
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 8
Column 3  /
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated
Column 1 /
Column 2 9
Column 3 


---------------------

importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 1:
 "BEGIN   sys.dbms_ijob.submit(job=>1,luser=>'SYSTEM',puser=>'SYSTEM',cuser=>"
 "'HONDAPROD',next_date=>to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS"
 "'),interval=>'add_months(to_date(to_char( sysdate , ''dd-mon-yyyy hh24:mi:s"
 "s''), ''dd-mon-yyyy hh24:mi:ss''),  1 )',broken=>TRUE,what=>'HONDAPROD.EUL$"
 "SR31SUMMARY120662.EXECUTE(next_date, job);',nlsenv=>'NLS_LANGUAGE=''AMERICA"
 "N'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA"
 "'' NLS_NUMERIC_CHARACTERS=''.,'' NLS_DATE_FORMAT=''DD-MON-RR'' NLS_DATE_LAN"
 "GUAGE=''AMERICAN'' NLS_SORT=''BINARY''',env=>'0102000200000000'); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_IJOB", line 210
ORA-06512: at line 1
. importing HONDAPROD's objects into HONDAPROD
. importing SYSTEM's objects into SYSTEM
About to enable constraints...
. importing SCOTT's objects into SCOTT
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. importing VIDEO31's objects into VIDEO31


please see & advice
Re: Upgrade 8i to 10g [message #480820 is a reply to message #480806] Wed, 27 October 2010 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
import only the schema you want (not system/sys and other option schemas).
Re: Upgrade 8i to 10g [message #480825 is a reply to message #480820] Wed, 27 October 2010 07:41 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thank Mahesh

but whta is the meaning of full=y

this is first time i m upgrade using imp/exp
please explain.
Re: Upgrade 8i to 10g [message #480830 is a reply to message #480825] Wed, 27 October 2010 08:01 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2431
Previous Topic: DBMS_DATAPUMP IMPORT Error (4 Merged)
Next Topic: SQL Function Greatest
Goto Forum:
  


Current Time: Thu Mar 28 20:01:14 CDT 2024