Downgrading from Enterprise to Standard Edition (version 8.1.7)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Downgrading from Enterprise to Standard Edition (version 8.1.7)

  1. #1
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88

    Question Downgrading from Enterprise to Standard Edition (version 8.1.7)

    We need to downgrade from Enterprise Edition to Standard Edition. I would like to know if anyone has done this (according to Oracle's Metalink)? If so, what was the procedure?

    Everything in Metalink kept refering to Note: 139642.1. This note to me seems to be incomplete. Would this be the high-level steps according to Note 139642.1?

    1) Full export of the current Enterprise Edition database.
    2) Uninstall the Enterprise Edition.
    3) Install the Standard Edition.
    4) Import the .dmp file from the Enterprise Edition.

    Any additional information would be greatly appreciated.

    Thanks,
    smoothyc

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, seems like a lot of work, but I've never done it. I'm not sure why you couldn't just install SE in a new $OH, shutdown the database, switch to the new $OH, startup your database, re-run catalog.sql, catproc.sql (just for kicks) and go....

    Of course, I may be way off base here...
    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."

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I wouldn't like to try it for the first time on my production system, that's fer sure.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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