1.7 Operational Issues and Troubleshooting

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

1. If there are objects with version number other than 1 and While enabling editions for the User <Schema name> in section Pre-Requisite will result with the below error
   “ERROR at line 1:

   ORA-38820: user has evolved object type"

   Solution:

   Below query will list the objects with version number other than one.

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

   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 section Drop Patch Set Edition if there are active connections to the schema pointing to Patch set 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 Patch set Edition dropped

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

   Select * FROM all_editions