Re: Oracle 8 export - Oracle 7

Ron, good luck with it, oracle doesnt really support going backwards especially with changes in 8i, are you sure you didnt use any 8 or 8i features in the tables you want to export, i just did an 8.1.6 downgrade to 8.0 and there was so many things i had to just drop and recreate afterwards due to incompatibilities.

you might be better off(if possible), to do the .dmp w/o rows, strip out the DDL, run it in the 7 db, setup up a db link and suck the data across the db link. I realize this might not be feasible but i'll bet it would be the least painful.

joe

"Smith, Ron L." wrote:

> I have an Oracle 8i database that I need to export a schema and import it
> into an Oracle 7.3 database. I tried copying a few of the exp73 dlls and
> exe's but I am not having much luck. Can anyone help?
>
> Thanks!
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 10 2000 - 14:55:53 CDT