1 Reply Latest reply: Nov 15, 2012 2:43 AM by Osama_Mustafa RSS

    Downgrade from EE to SE edition

    rootsman
      Hi guys,

      I have started to migrate 11.2.0.3 database from Enterprise to Standard edition with expdp/impdp (RHEL box). I've managed to transfer database without any problem (ok i had little diffiulties with bitmap indexes but nevermind).

      But now i do not have all public synonyms in place as i already knew. So i have to create sql script and i have found several good ones.

      My question is do i need to recreate all public synonyms or there is a exceptions in my case because i now have Standard Edition database (old one was Enterprise)?

      Thank you

      Edited by: rootsman on Nov 30, 2012 12:23 AM