Re: Exp from 8.0.5.0.0, import into 7.3.4.0.0

Setup a database link in database B to database A, and use the sql*plus COPY command,
or use export on 7.3.4 against the Oracle 8 database after having run catexp7.sql on the Oracle 8 database.

Hth,

Sybrand Bakker, Oracle DBA

Shannon St. Dennis <sstdenni_at_cityregina.com> schreef in berichtnieuws 3912fa79$1_at_news3.cableregina.com...
> 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
> 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
> current configuration.
>
> Shannon St. Dennis
> sstdenni_at_cityregina.com
>
>
Received on Fri May 05 2000 - 00:00:00 CEST