Re: Oracle Conversion & replication

"Richard Cassidy" <richardcassidy_at_ozemail.com.au> wrote in message news:<8HMw9.23077$Sr6.680455_at_ozemail.com.au>...
> Need to export OS/390 DB/2 to Oracle 8.1.7 on IBM pSeries running AIX 4.1.3
> then replicate the database to Oracle 7.1 running on NT 4.0 SP6 Servers. The
> static Oracle data is read heavily, the database is updated hence replicated
> maximum once a day.
>
> Does any one see areas to be observed with data conversion or reasons to
> force the workstation application accessing the Oracle 7.1 database to be
> re-certified (to ensure availability and no confliction with other desktop
> applications) to version 8. Note the Unix server Oracle 8.1.7 is mandatory.
>
> Cheers

Depending on your data, it sounds like your best bet would be to export the data to flat files, then use SQL*Loader to insert to each. It is difficult to use the oracle exp/imp to go from 817 to 71. Look around, there are various scripts floating about to handle the converse of SQL*Loader.

I expect you may have some serious conflicts with the workstation apps, if they must access the 7 db and other things. Be real careful with ORACLE_HOMES there. The client issues depend on whether you are using Oracle client software like forms or third party ODBC or OCI or what... get on metalink and be sure you understand the SQL*Net version issues.

jg

--
@home.com is bogus.
253, 0, "DB2 partition number has no significance -- ignored\n"
// *Cause: The SQL*Loader control file contains a PART statement.
//         SQL*Loader ignores this clause.