Re: export data from 8i using 7.3.4 export utility

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Tue, 17 Aug 1999 04:48:48 GMT
Message-ID: <QQ5u3.82$wB.14368@ratbert.tds.net>

We also encountered this problem. Oracle Support tells us that 8i allows self-referential constraints (I believe it is in many of the Java tables) but 7.3.4 does not. Not much you can do. we ended up creating another 8i database (without Java), exp/imp between the 8i databases, then exp/imp between the "new" 8i database and the 7.3.4 database.

HTH
Mike

tpcmohan_at_my-deja.com wrote in message <7p9skq$mb5$1_at_nnrp1.deja.com>...
>I was trying to export user data from 8i(exporting using exp7.3.4
>utility) i already ran the script catexp7.sql ,i am getting errors like
>EXP-00008 : ORACLE error 1436 ENCOUNTERED
>ORA-01436 : CONNECT BY loop in user data
>EXP-00000: Export terminated unsuccessfully. but export works fine with
>exp 8i version...i don't understand the cause???????
>...........i need to import that user data into 7.3.4 database ASAP
>waiting for reply...
>thanx
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 23:48:48 CDT