Home » RDBMS Server » Server Administration » Convert Enterprise Edition DB to Standard Edition (11.1, Solaris)
Convert Enterprise Edition DB to Standard Edition [message #530034] Fri, 04 November 2011 04:44 Go to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.
Can anyone come up with solid reason why this should not be done? Perhaps an example of a problem? The note says only Quote:
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.
and this isn't really strong enough for me to refuse to do it.
Re: Convert Enterprise Edition DB to Standard Edition [message #530037 is a reply to message #530034] Fri, 04 November 2011 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You should better ask Oracle but this sentence is just a way for Oracle to say that if you do so then you are on your own as they no more support your configuration.
So if the fact that Oracle will no more support you is not sufficient enough to not do so then proceed.

Regards
Michel
Re: Convert Enterprise Edition DB to Standard Edition [message #530183 is a reply to message #530037] Sun, 06 November 2011 02:13 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Thank you for replying. We have a TAR open. Not nice situation, but nothing to be done about it.
John.
Previous Topic: ORA-08103
Next Topic: montoring autoallocate tablespaces
Goto Forum:
  


Current Time: Fri Nov 29 04:31:58 CST 2024