Database Administration (MOSC)

MOSC Banner

SYS.KU$_XMLSCHEMA_ELMT_VIEW - has different DDLs en different databases

edited Feb 13, 2011 3:14PM in Database Administration (MOSC) 5 commentsAnswered ✓
BANNER
----------------------------------------------------------------
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center