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

Thread: Donwgrading Oracle

  1. #1

    Question

    Any tips on this before I go ahead and downgrade 8.1.7 to 8.1.6



  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Take a full cold backup of ur Oracle 8.1.7 database after shutting down the database.

    Regards,
    Santosh

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134

    Lightbulb

    This may or may not affect your optimizer, you might want to run an analyze after this procedure.
    MH

  4. #4


    Now that is an excellent tip.


    Change of plan though. Instead the plan from upstairs is to restore the test server from a version of Oracle 8.1.6 they know was working the way they want it. Then I will simply export the data from the Oracle 8.1.7 database into the newly restored Oracle 8.1.6.


    Is there going to be a compatibility issue using 8.1.7 exporting tool and 8.1.6 importing tool.

  5. #5
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Yes there are issues related with exporting data from oracle 8.1.7 to importing into Oracle 8.1.6

    Perform a search on this forum you will find tons of information on export and import

    Regards
    Santosh

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134

    Lightbulb

    I had this problem before in an import/export situation. We simply changed the Oracle home to point to the corrcet version. This can be done in your .par file
    Mr.Hanky@old_version
    Got it?
    MH

  7. #7
    Nope, 8.1.7 is installed on the live machine and 8.1.6 is installed on the test server.

    We want to get the live data into the test server. I am using export (8.1.7) and import (8.1.6).

    I think the best solution is to install the 8.1.6 software on the live server and export using that.

    So I export using 8.1.6 and import using 8.1.6


    I did the search as well and found an interesting comment that 8.1.6 export is full of bugs.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You can also check out asktom.oracle.com and search the archives for "export" and "version" and you will see several hundred questions answered about this exact problem.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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