DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Exp from higer version to lower version

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Exp from higer version to lower version

    If i need to transfer data from a higher version to a lower version, you will need to use the export utility from the lower version database.

    Say for ex, i need to export from 9.2.0 to 8.1.7

    How can i use the export utility of 8.1.7 on the 9.2.0 machine.

    Do i have to install the exp/imp components of 8i on 9i machine or is this has to be done using 8i client machine?

    Can somebody avise me on this.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Well, look at the parameter for userid. You can set userid=username/password@SID. That is how you would/could connect.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Exp from higer version to lower version

    Originally posted by bang_dba
    If i need to transfer data from a higher version to a lower version, you will need to use the export utility from the lower version database.

    Say for ex, i need to export from 9.2.0 to 8.1.7

    How can i use the export utility of 8.1.7 on the 9.2.0 machine.

    Do i have to install the exp/imp components of 8i on 9i machine or is this has to be done using 8i client machine?

    Can somebody avise me on this.
    Of course from an 8i client. Via Net8.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    May 2001
    Posts
    736

  5. #5
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    The rule on thumb is to always export with the lower version of the both db versions exp utility. Then import with the higher one.

    So go to your 8i database, create a tns alias in tnsnames.ora to the 9i database, then use from the 8i to export the 9i db. In the export parameter file set this up: USERID=user/password@tnsname-9i-db .....

    Once you are done, FTP the dump file to the 9i db, and import with the 9i imp binary.


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

  6. #6
    Join Date
    May 2003
    Location
    hyderabad, India
    Posts
    10
    hi

    To export data from oracle 9i version to oracle 8i, configure tnsnames.ora (oracle 9i database), on either oracle 8i server or client which is in network with the Oracle 9i server. Run exp command from either of these with connect string as the newly defined connect string(Oracle 9i).

    The dump file created will be compatible to Oracle 8i version. This dump file can be imported into Oracle 8i database.

    I hope this solves ur problem.

    Regards

    Partha

  7. #7
    Join Date
    Jun 2000
    Posts
    295
    julian

    What do you mean by say:

    Oracle Certified Professional 6i

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by sysdba
    julian

    What do you mean by say:

    Oracle Certified Professional 6i
    Oracle Developer 6i, I guess.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width