Export/import from 7.x to 8.0.4.3 Errors

From: Huy Vu <huyv_at_usa.net>
Date: Sat, 20 Mar 1999 21:35:00 -0500
Message-ID: <36F45AD4.1A986DE8@usa.net>

Hi all,

I'm trying to do a full export of an oracle database 7.x on Dec Unix 4.0B with 'system' user and import into an oracle database 8.0.4.3 on Dec Unix 4.0D.

The import terminated successful with warnings instead of many errors as following.

. . importing table                "DEF$_CALLDEST"          0 rows

imported
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF$_CALLDEST_PRIMARY"
PRIMARY"
" KEY

("DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","CALLNO","DUMMY_BUFFER_NUMBER","
""DBLINK") USING INDEX STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXEXT"
"ENTS 121 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "TOOLS""
IMP-00003: ORACLE error 904 encountered ORA-00904: invalid column name

IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_ERROR" ADD CONSTRAINT "DEF$_ERROR_PRIMARY" PRIMARY
KEY ("
""DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","DESTINATION") USING INDEX
STORAGE (I"
"NITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50
FREELIST"
"S 1 ) TABLESPACE "TOOLS""

IMP-00003: ORACLE error 904 encountered ORA-00904: invalid column name

IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "ACCES" ("USER_ID" CHAR(15), "MODULE_NAME" CHAR(20),
"PERMISSI"
"ONS" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(IN"
"ITIAL 20480 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50
FREELISTS"
" 1 FREELIST GROUPS 1) "
IMP-00003: ORACLE error 1950 encountered ORA-01950: no privileges on tablespace 'SYSTEM'

IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "BI" ("BITAG" NUMBER(*,0), "DESCRIPTION" CHAR(60),
"CREATE_DAT"
"E" NUMBER(*,0), "MODIFY_DATE" NUMBER(*,0), "SOURCE" CHAR(1), "W_OR_M"
CHAR("
"1), "REF_COUNT" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255"
" STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121
PCTINCREASE 5"
"0 FREELISTS 1 FREELIST GROUPS 1) "
IMP-00003: ORACLE error 1950 encountered ORA-01950: no privileges on tablespace 'SYSTEM'

.........................................................................................................

Do I have a special option in importing from 7.x to 8.x ?

Thanks in advance for any help...

H.V Received on Sat Mar 20 1999 - 20:35:00 CST