Re: An Export/Import problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/19
Message-ID: <961435358.28388.0.pluto.d4ee154e@news.demon.nl>#1/1

You need to do the following
- run $ORACLE_HOME/rdbms/admin/catexp6.sql against the Oracle 7 database using svrmgrl

- use the exp of Oracle 6 to export the database
- use imp of Oracle 6 to import it
- *Get rid of both Oracle 6 and Oracle 7 ASAP as soon you will work

with -TWO- unsupported major releases *

Hth,

Regards,

Sybrand Bakker, Oracle DBA

""Marco Pinzuti"" <mpinzuti_at_virgilio.it> wrote in message news:627BCB9203544D11782400807CFD9B59_at_mpinzuti.virgilio.it...
> Does anyone know how it's possible to accomplish an import under UNIX
> of a DMP file containing a table (structure and data) from Oracle 7 to
> Oracle 6?
>
> Thanks in advance
>
> I point out to all of you that I use the command-line IMP
 'USER/PASSWD'under UNIX for importing the table.
>
>
> ===========================================================
>
> VIRGILIO MAIL - Il tuo indirizzo E-mail gratis e per sempre
> http://mail.virgilio.it/
>
>
> VIRGILIO - La guida italiana a Internet
> http://www.virgilio.it/
>
> --
> Posted from [216.163.180.10]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Jun 19 2000 - 00:00:00 CDT