This topic describes on the common issues and its troubleshooting methods.

1. If there are objects with a version number other than one and while enabling editions for the User <Schema name> in the topic Pre-Requisite will result with the error

   ERROR at line 1:ORA-38820: user has evolved object type

   Solution:

   The below query will list the objects with a version number other than one.

   Select type_name,owner, version# from dba_type_versions where owner='&SCHEMA_NAME' and VERSION# !='1';

   The below query’s result to be executed in SQL command prompt to reset the version to one.

   Select 'ALTER TYPE ' ||TYPE_NAME|| ' RESET;' FROM dba_type_versions where owner='&SCHEMA_NAME' AND VERSION# !='1';
2. Patch set edition will not be dropped in the topic Drop Patch Set Edition, if active connections to the schema point to Patch set Edition.

   Exception in dropping edition java.sql.SQLException: ORA-38805: edition is in use.

   Solution:

   Clear such sessions and topic Drop Patch Set Edition to process again to get the Patch set Edition dropped.

3. The below query would help to list all editions in the Schema. At the end of the process, Drop Patch Set Edition, only Base Edition, should present.

   Solution:

   Select * FROM all_editions