oracle+xsl,ORA-39212:安装错误:未正确加载XSL样式表

ORA-39212: 安装错误: 未正确加载 XSL 样式表

ORA-39212: 安装错误: 未正确加载 XSL 样式表:

问题描述

SQL> select dbms_metadata.get_ddl('TABLESPACE','TEST') from dual;

ERROR:

ORA-39212: 安装错误: 未正确加载 XSL 样式表

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7398

ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7447

ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 9453

ORA-06512: 在 "SYS.DBMS_METADATA", line 1919

ORA-06512: 在 "SYS.DBMS_METADATA", line 2792

ORA-06512: 在 "SYS.DBMS_METADATA", line 4333

ORA-06512: 在 line 1

no rows selected

原 因

The XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary table "sys.metastylesheet."

It may be the cause that the stylesheets were not loaded at all in the database, or they were not converted to the database character set.

Suppose if you convert your database character set using ALTER DATABASE statement then likely you will face this problem.

解决方法

Note that never use ALTER DATABASE statement to migrate your characterset.

1)Connect as sysdba.

SQL> sqlplus /nolog

SQL> connect / as sysdba

Connected.

2)Execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

SQL> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

3)Exit and run the above query,

SQL>exit

推荐阅读：

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏，或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

，

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网