ORA-39212: Installation Error: incorrect loading of XSL style sheet

Source: Internet
Author: User
Tags xsl

Problem description
SQL> select dbms_metadata.get_ddl ('tablespace', 'test') from dual;
ERROR:
ORA-39212: Installation Error: incorrect loading of XSL style sheet
ORA-06512: In "SYS. DBMS_SYS_ERROR", line 79
ORA-06512: In "SYS. DBMS_METADATA_INT", line 7398
ORA-06512: In "SYS. DBMS_METADATA_INT", line 7447
ORA-06512: In "SYS. DBMS_METADATA_INT", line 9453
ORA-06512: In "SYS. DBMS_METADATA", line 1919
ORA-06512: In "SYS. DBMS_METADATA", line 2792
ORA-06512: In "SYS. DBMS_METADATA", line 4333
ORA-06512: In line 1
No rows selected
Origin
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.
Solution
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.