I have installed Oracle database and I chose the Enterprise Edition option when installing. I did this incorrectly and meant to install the standard edition. How can I "downgrade" this installation from Enterprise to Standard without deleting and reinstalling it. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Downgrade Oracle Enterprise Edition Database to Standard Edition
- Thread starter hellsing
- Start date
SantaMufasa
Technical User
Hellsing,
As far as you understand it, what is the difference between Standard Edition and Enterprise Edition?
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
As far as you understand it, what is the difference between Standard Edition and Enterprise Edition?
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
- Thread starter
- #3
Hi thanks for the reply,
As I understand it, Enterprise Edition comes with extra functionality such as bitmap indexes and also allows extra bolt ons such as for clustering.
If I do a select * from v$version it comes back with Enterprise Edition and I don't want this. I need to "downgrade" this install so it comes back with Standard Edition. Thanks.
As I understand it, Enterprise Edition comes with extra functionality such as bitmap indexes and also allows extra bolt ons such as for clustering.
If I do a select * from v$version it comes back with Enterprise Edition and I don't want this. I need to "downgrade" this install so it comes back with Standard Edition. Thanks.
SantaMufasa
Technical User
Hellsing,
I am not aware of a method to simply set (or unset) a parameter to disable Enterprise Edition, thus enabling Standard Edition. If you wish to "gear down" to Standard Edition, then here are the steps that I recommend:
1) Export the Oracle users' schemas that you want in the Standard database.
2) Uninstall Oracle Enterprise Edition.
3) Install Oracle Standard Edition.
4) Create a new, Standard Edition database.
5) Create the target users.
6) Import the dump files you created in Step 1, above.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
I am not aware of a method to simply set (or unset) a parameter to disable Enterprise Edition, thus enabling Standard Edition. If you wish to "gear down" to Standard Edition, then here are the steps that I recommend:
1) Export the Oracle users' schemas that you want in the Standard database.
2) Uninstall Oracle Enterprise Edition.
3) Install Oracle Standard Edition.
4) Create a new, Standard Edition database.
5) Create the target users.
6) Import the dump files you created in Step 1, above.
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
- Thread starter
- #5
SantaMufasa
Technical User
Hellsing,
Out of curiosity, do you have an Enterprise Edition license? If so, why go to the trouble of "unhooking" functionality? If not, then congratulations on your integrity!![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
Out of curiosity, do you have an Enterprise Edition license? If so, why go to the trouble of "unhooking" functionality? If not, then congratulations on your integrity!
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question