How To Cleanup Invalid Oracle iSetup (AZ) Tables And Recreate
(Doc ID 832459.1)
Last updated on SEPTEMBER 20, 2018
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document