Hi All,
I’ve problem smon when restore oracle DB EE to oracle DB SE. it can be possible restore DB EE to DB SE ? i search in oracle forum, using rman it’s not possible to restore DB EE to DB SE, must migrate the data. i using CV 11.20. My pfile and spfile is copied from DB EE to DB SE and set same DB ID too. Anyone have same problem ?
Hi
I asked one of my colleges whom seems to an Oracle geek 
He says “No you can’t”. You basically have to do an export / import into a new DB. The other other way around, though, is easy he says…. what ever he means by this :-) So if this isn’t possible (or supported) within Oracle itself, I’m sure Commvault won’t be able to do this either..
Have a great day..
Kind regards
Rubeck
As per Oracle Support document
Converting An Enterprise Edition Database To Standard Edition (Doc ID 139642.1)
The only way to properly convert from an Enterprise Edition back to a Standard Edition is through an Export/Import operation
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.