Results 1 to 2 of 2

Thread: Downgrade

  1. #1
    Join Date
    Nov 2002
    Location
    Holland
    Posts
    11

    Unanswered: Downgrade

    Can someone tell me if it possible to downgrade a oracle Enterpride Edition database to a Oracle Standard Edition ?
    Is it possible to export a entire database from a Oracle Enterprise to a Standard Edition ?
    What problems can be expected ?

    Best regards,

    Cecodeel

  2. #2
    Join Date
    Feb 2005
    Posts
    2
    Quote Originally Posted by cecodeel
    Can someone tell me if it possible to downgrade a oracle Enterpride Edition database to a Oracle Standard Edition ?
    Is it possible to export a entire database from a Oracle Enterprise to a Standard Edition ?
    What problems can be expected ?

    Best regards,

    Cecodeel
    Due to the differences between both versions when using the various Options, you cannot simply convert from an Enterprise Edition to a Standard Edition. The problem lies in the fact that the Enterprise Edition contains lots of Data Dictionary objects which are not available in the Standard Edition. When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.

    Solution : The only way to properly convert from an Enterprise Edition back to a Standard Edition is through an Export/Import operation. This way you will get rid of all Enterprise Edition specific Data Dictionary objects, as the SYS schema objects are not exported. After the Import in the Standard Edition database, you only need to drop all user schemas related to Enterprise Edition features, such as the MDSYS account (used with Oracle Spatial). NOTE: You CAN convert from EE to SE by running the CAT* scripts, but you may see objects in the data dictionary that no longer apply. If you do not want to cleanup the invalid objects, then you will have to install the EE software, create a database and import.

Posting Permissions

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