Re: exporting some tables from Oracle 8.0.5 to Oracle 7.3.4

You need to run catexp7.sql in $ORACLE_HOME/rdbms_admin using svrmgrl against the Oracle 8 database. After this, you need to run exp from Oracle 7 against the Oracle 8 database.

Hth,

Sybrand Bakker, Oracle DBA

Shannon St. Dennis <sstdenni_at_cityregina.com> schreef in berichtnieuws 3922bbc1$1_at_news3.cableregina.com...
> Hi
>
> 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
> 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.
>
> 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