exporting some tables from Oracle 8.0.5 to Oracle 7.3.4

Hi

[Quoted] I hate to rehash old news but I really need a solution to this one...

DatabaseA is at oracle v8.0.5
DatabaseB is at oracle v7.3.4

I need to export some tables from databaseA and import them into databaseB

Is there a quick/easy way to do this?

I am on AIX v4.2.1. Each database is on a different server. I am thinking [Quoted] of using replication in the long run and I will be updating DatabaseB to 8.1.6 in a few months but for now I need to copy these tables around in the [Quoted] current configuration.

Oracle 7 does not recognize the Oracle 8 exp format. If I use a remote dblink and try to exp from the Oracle 7 database (eg. exp user/password_at_DatabaseA tables=...), it says "Exp-00024: Expor views not installed"
I'm guessing that is because the oracle 8 export views are different than the oracle 7 ones.

Am I stuck with using a sql statement (select) to create a delimited ascii file, then use sql*loader to load it into the 7.3 database?

Shannon St. Dennis
sstdenni_at_cityregina.com Received on Wed May 17 2000 - 00:00:00 CEST