Re: Version problem in Import Export

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 19 Jan 2003 09:30:57 -0800
Message-ID: <92eeeff0.0301190930.183954e0_at_posting.google.com>


imranserver_at_yahoo.com (Muhammad Imran) wrote in message news:<ed222491.0301190045.2560f91a_at_posting.google.com>...
> Hello All!
>
> I have dump of oracle 8.1.7 .How can i import it from Oracle7.
> Of course there is version problem.Please anybody can tell me what
> would be an easy alternative method to do this job.
>
> Thanks!

If I understand you correctly, you have a dump file of 8.1.7 and you want to import it into V7. Here are some steps that must be taken to downgrade from V8 to V7.

  1. Make sure $ORACLE_HOME/rdbms/admin/catexp7.sql is deployed in V8 database before export is taken.
  2. Use V7 exp utility to create the dump of V8 database. This is important as export taken using V8 exp will not work to downgrade.
  3. Use V7 imp utiltiy to import data into V7 database.

Regards
/Rauf Sarwar Received on Sun Jan 19 2003 - 18:30:57 CET

Original text of this message