Re: Export/import from 7.x to 8.0.4.3 Errors

In article <36F45AD4.1A986DE8_at_usa.net>, huyv_at_usa.net says...
> 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"
Don't do a full import. If you do that you'll bring in the 7.x tables, which as you have discovered don't work too well in 8.0.

I imported a 7.2 export into an 8.0.4 instance. I just imported it user by user. Luckly for me there were not too many users. I have not used the migration tool so I can't help you there.

Liz
--
My real address is L R E E N a t P E R R I E R G R O U P d o t C O M Received on Thu Apr 01 1999 - 14:25:06 CST