This discussion is archived
1 Reply Latest reply: Nov 15, 2012 12:43 AM by Osama_Mustafa RSS

Downgrade from EE to SE edition

rootsman Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points