Re: Oracle 7.3.3 to 8.0.4 migration using exp/imp -Problems

This is what I found from Oracle Support web Page:

This is bug 434600, according to the bug, it is a problem where Oracle8 has a column on the DEF$_DESTINATION table that doesn't exist in v7.

According to development, the error can be ignored.

Regards,
Satar

PS If I violate my Agreement with Oracle Support by posting this, please let me know.

In article <01be203d$96ffe840$76d915a5_at_oempre-install>,   "Sanjay Hans" <sanhans_at_mbox5.singnet.com.sg> wrote:
> I am trying to do migration from Oracle 7.3.3 on Digital Alpha unix to
> Oracle 8.0.4 on Digital Alpha NT. I took the full export backup as
> 'system' user from Oracle 7.3.3 and installed the Oracle 8.0.4 on NT. I
> created all the required tablespaces/rollback segments in Oracle 8.0.4
>
> For importing the backup a gave the command: -
> Imp80 system/manager file=full.db full=y ignore=y log=full.log
>
> The log files is showing following lines:
>
> Connected to: Oracle8 Enterprise Edition 8.0.4.1.0 - Very Large Memory
> (VLM) - Production
> PL/SQL Release 8.0.4.1.0 - Production
>
> Export file created by EXPORT:V07.03.03 via conventional path
> . importing OEM's objects into OEM
> . importing SYSTEM's objects into SYSTEM
> . importing table "DEF$_CALL" 0 rows imported
> . 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","DBLINK") USING
> INDEX "
> "STORAGE (INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE
> 5"
> "0 FREELISTS 1 ) TABLESPACE "SYSTEM""
> IMP-00003: ORACLE error 904 encountered
> ORA-00904: invalid column name
> IMP-00017: following statement failed with ORACLE error 904:
> "COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_DB" IS 'Originating
> datab"
> "ase for the deferred transaction'"

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 13:42:22 CST