Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: move a database from Oracle8 enterprise to Oracle8 standard

    Have anybody any experience with 'downgrading' a Oracle8 Enterprise Edition to a Oracle8 Standard Edition.

    They are running on a windowsNT and is moving an application to a windows2000, furthermore they want to move their application to Standard Edition to save money.

  2. #2
    Join Date
    Feb 2005
    Posts
    2

    Converting DB from EE to SE

    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.

    Regards,

    Sid

Posting Permissions

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