How to compile Invalid Objects
Hi Expert,
My export is not happening, when i query dba_objects. I have found the some tables and XML Schema are invalid. Please tell how do I compile them.
OWNER OBJECT_NAME OBJECT_TYPE CREATED STATUS
--------------- ------------------------------ --------------- --------- -------
XDB XD6og1dpvWRp2783XLf2dJag== XML SCHEMA 12-MAY-02 INVALID
XDB XDHmlQI6HpQoWwQTjZDrAysw== XML SCHEMA 12-MAY-02 INVALID
XDB XDL4qxnDVyRO+Gx7z4UDqUew== XML SCHEMA 12-MAY-02 INVALID
XDB XDMDRUknLySMaSqR8cYZCjZQ== XML SCHEMA 12-MAY-02 INVALID
XDB XDeANTEZn/R7WgoNhsuVu7OA== XML SCHEMA 12-MAY-02 INVALID
XDB XDeL+R1jTrS02oYnnC3qW43A== XML SCHEMA 12-MAY-02 INVALID
XDB XDefPU46scRPORRSMMAaNvAA== XML SCHEMA 12-MAY-02 INVALID
OE CATEGORIES_TAB TABLE 12-MAY-02 INVALID
OE SUBCATEGORY_REF_LIST_NESTEDTAB TABLE 12-MAY-02 INVALID
Thanks in advance
Shaan