Is it possible to transfer data From oracle8i to oracle7.3.4?

[TTLTD]

Hi all

Is it possible to transfer data From oracle8i to oracle7.3.4?


We have a main database(oracle7.3.4) running on Sco Unix.We also have
few other databases(Oracle8i) running on windows platform.We want to transfer data from oracle 8i to to our main database(oracle 7.3.4).
Is this possible ?

Regards
TTL

 

[shameel]

hi ttltd
currently it is not possible to transfer data from new version of oracle to old one. as new have all capabilities to support previous versions. but old version can't support the new ones options.
with regards

 

[sem]

You may do it using database link.

Regards, Dima

 

[Advocate]

alternatively, you could also do it by exporting data to a flatfile from 8i and then using sql-loader to import into 7x - not the prettiest of solutions but it works - i once worked with a dba that refused to setup db links for security reasons - watch the data types and field lengths etc


no such thing as problems - only solutions.

 

[dsanchez2]

You can transfer data from a Oracle 8 to Oracle 7 database using one of the following methods:

(1) You can stablish a database link between the Oracle 8 to the Oracle 7 database. Then you can simply use standard SQL statements on the Oracle 7 database to SELECT and INSERT the data.

(2) You can export the data using the Oracle 7 export utility on the Oracle 8 database. It is important that you use the Oracle 7 export utility. You can not import an export file created by the Oracle 8 export utility. Before using the export 7 you may have to run the catexp7.sql script on the Oracle 8 database -- you find this in the "rdbms/admin" directory of your Oracle Home. This script creates the Data dictionary views required by the Oracle 7 export.