How To Cleanup Invalid Oracle iSetup (AZ) Tables And Recreate

(Doc ID 832459.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle iSetup - Version 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:

PLS-00905: object AZ.AZ_<xXxXx> is invalid

Where, "AZ_<xXxXx>" include mainly 3 tables owned by AZ schema:


As a result, iSetup Requests fail with:

ORA-31000: Resource '' is not an XDB schema document
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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms