How To Cleanup Invalid Oracle iSetup (AZ) Tables And Recreate
Last updated on APRIL 12, 2017
Applies to:Oracle iSetup - Version 18.104.22.168 to 12.2 [Release 11.5.10 to 12.2Cloud]
Information in this document applies to any platform.
There are often some unwelcome situations, where iSetup tables which are having column of data-type "SYS.XMLTYPE", become Invalid. Some of the possible examples are:
Where, "AZ_<xXxXx>" include mainly 3 tables owned by AZ schema:
As a result, iSetup Requests fail with:
ORA-06512: at "SYS.XMLTYPE", line 214
ORA-06512: at line 1
This is a scenario, where all the previous iSetup Requests and iSetup Reports become non-recoverable. But there is a workaround to recreate those tables and reuse iSetup.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms