import error?
529547Dec 19 2006 — edited Dec 20 2006Hello All,
I have exported backup of 9i and i want to import it to 10g when i do the process it give me following error
==================================================
[oracle@portal bin]$ cat /u01/IMPORT.LOG
Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by IUSR, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing IUSR's objects into SYS
IMP-00017: following statement failed with ORACLE error 4089:
"CREATE TRIGGER "SYS"."ADJ_TRIG" BEFORE"
"INSERT ON "CONCURSO_ADJ" FOR EACH ROW BEGIN"
"SELECT LOTE_ID.nextval INTO :NEW.LOTE_ID FROM dual;"
"END;"
IMP-00003: ORACLE error 4089 encountered
ORA-04089: cannot create triggers on objects owned by SYS
IMP-00017: following statement failed with ORACLE error 4089:
"CREATE TRIGGER "SYS"."NEWS_TRIG" BEFORE"
"INSERT ON "NEWS_TBL" FOR EACH ROW BEGIN"
"SELECT NEWS_ID.nextval INTO :NEW.NEWS_ID FROM dual;"
"END;"
IMP-00003: ORACLE error 4089 encountered
ORA-04089: cannot create triggers on objects owned by SYS
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>23,WHAT=>'TNDR_TBL_UPDATE;',NEXT_DATE=>TO_DAT"
"E('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'sysdate + 1',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 97
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>24,WHAT=>'GW_TNDR_TBL_UPDATE;',NEXT_DATE=>TO_"
"DATE('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'sysdate + 1'"
",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 97
ORA-06512: at line 1
About to enable constraints...
Import terminated successfully with warnings.
===========================================================
any idea, thanks