Oracle Database Discussions

Hi All,

What is the way to downgrade 10g enterprise edition to standard edition version 10.2.0.1.0.

Is it a un-installation of enterprise and installation of standard edition or if we can do with downgrading by running few scripts in the database and which brings down the db to standard edition.

1) What are the known issues in downgrading to enterprise to standard edition of 10g Release 2 software.
i.e 10.2.0.1.0. Any referral links or metalink documents will do.

2) How to find the features which are enterprise edition related. i.e Is there a query/way to find the features used in a schema which are enterprise edition.

Thanks in advance