SYS.KU$_XMLSCHEMA_ELMT_VIEW - has different DDLs en different databases
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
The above is a test database we are using. When executing the following SQL we received the following error
SELECT DBMS_METADATA.GET_DDL('TABLE', 'VWM_VALORACIONES_AUXILIARES', 'ADM_CIBELES' ) || chr(13) ||chr(10) ||'/' txt
FROM dual
/
ERROR:
ORA-04063: view "SYS.KU$_FHTABLE_VIEW" tiene errores
ORA-06512: en "SYS.DBMS_METADATA", línea 1548
ORA-06512: en "SYS.DBMS_METADATA", línea 1585
ORA-06512: en "SYS.DBMS_METADATA", línea 1902
ORA-06512: en "SYS.DBMS_METADATA", línea 2793