解决ORA-39212: installation error: XSL stylesheets not loaded correctly

 

通过ddl查询建表语句：

SQL> select dbms_metadata.get_ddl('TABLE','DOMAIN') from dual;

出现以下错误：

‍ERROR:
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 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

‍解决方法：
以sysdba权限的用户登陆执行以下语句：

SQL> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

再次执行

‍

SQL> select dbms_metadata.get_ddl('TABLE','DOMAIN') from dual;

DBMS_METADATA.GET_DDL('TABLE','DOMAIN')
--------------------------------------------------------------------------------

CREATE TABLE "MC"."DOMAIN"
   (    "ID" NUMBER(11,0) NOT NULL ENABLE,
        "DOMAIN
....

问题得以解决。