This content has been marked as final. Show 3 replies
Refer to MOS Note :
*10G : Step by Step Procedure to Convert from Enterprise Edition to Standard Edition [ID 465189.1]*
This is possible only if you are not using any of the EE options that are not present in SE - for example, partitioning.
See the list here - http://docs.oracle.com/cd/B19306_01/license.102/b14199/editions.htm#BABJICBB
You will need to perform a complete export from 10gR2 and then a complete import into a new created 11gR2 database. Pl see the link I posted in your duplicate post in this forum