2.5 Operational Issues and Troubleshooting

This section briefs on the common issues and the troubleshooting methods.

1. If there are objects with a version number other than one and while enabling editions for the user in section Pre-Requisite (xref) 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. Patchset edition will not be dropped in section Drop Patch Set Edition (xref) if active connections to the schema point to Patchset Edition.

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

   Clear such sessions and section Drop Patch Set Edition to process again to get the Patchset 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 (xref), only Base Edition, should present.

   Select * FROM all_editions