Thanks Tom for picking up my question.

I have a request to replace the Oracle Enterprise edition database with the Standard edition for liscense cost reason. I know and understand the features difference between them.

My question is: what is the best way to do this.

My current solution is: Install Oracle standard edition software, create database, and transfer data from EE to SE(using expdp and impdp). It works fine.

I curious if I could directly copy the whole database files and let it run under the standard edition home. Are there some edition information in database files(control files, on line log files or data files)? or are they just in data dictionary? Could I manually update this information?

what is the difference on file level between these two editions?

Thanks.
Richard