When generating script to reorg XML objects the following errors comes up.
Error: "Application error: ORA-00942: table or view does not exist"
"Runtime error occurred: 942 (ORA-00942: table or view does not exist)"
Trace output from sql monitor will show:
select * from dba_xml_tab_cols where owner = :OWNER and table_name = :TABLE_NAME and column_name = :COLUMN_NAME
:OWNER = 'FAISMGR'
:TABLE_NAME = 'RCTXMLD'
:COLUMN_NAME = 'RCTXMLD_XMLDOC'
Space manager with Live reorg needs the XDB schema to reorganize tables with XML types, specifically for this issue: it needs the DBA_XML view.
To resolve this issue recreate this view. The script for this can be found in $ORACLE_HOME/rdbms/admin (grep for view name.)
