My Oracle Support Banner

ORA-39212 During Executing DBMS_METADATA.GET_DDL (Doc ID 1316223.1)

Last updated on DECEMBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2016***


You encounter an error ORA-39212 like below when executing DBMS_METADATA.GET_DDL

SQL> select DBMS_METADATA.GET_DDL('TABLE', 'table_name') from dual;

ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7771
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7806
ORA-06512: at "SYS.DBMS_METADATA_INT", line 10187
ORA-06512: at "SYS.DBMS_METADATA_INT", line 10383
ORA-06512: at "SYS.DBMS_METADATA", line 2341
ORA-06512: at "SYS.DBMS_METADATA", line 3227
ORA-06512: at "SYS.DBMS_METADATA", line 4812
ORA-06512: at line 1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.