The solution of executing DBMS_METADATA.GET_DDL newspaper ORA-39212

Source: Internet
Author: User
Tags xsl

Environment:
    Database: Oracle 10.2.0.4--64-bit
    operating system: Red Flag DC 5.0 --64-bit

Login with sys , execute DBMS_METADATA.GET_DDL to get the metadata of a table space error
Select DBMS_METADATA.GET_DDL (' tablespace ', ' PDA ') from dual;
ERROR:
ora-39212:installation error:xsl stylesheets not loaded correctly
Ora-06512:at "SYS. Dbms_sys_error ", line
Ora-06512:at" SYS. Dbms_metadata_int ", line 7428
Ora-06512:at" SYS. Dbms_metadata_int ", line 7477
Ora-06512:at" SYS. Dbms_metadata_int ", line 9495
Ora-06512:at" SYS. Dbms_metadata ", line 1920x1080
Ora-06512:at" SYS. Dbms_metadata ", line 2793
Ora-06512:at" SYS. Dbms_metadata ", line 4333
Ora-06512:at 1

View 10g online file now:
ora-39212:installation Error:xsl stylesheets not loaded correctly

cause:the XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary tab Le "Sys.metastylesheet." Either the stylesheets were not loaded at all, or they were does converted to the database character set.Action:connect as SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.


Workaround:
Execute the following statement with the user logged on with the SYSDBA permission:

sql> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.


To execute successfully again:

Sql> Select Dbms_metadata.get_ddl (' tablespace ', ' PDA ') from dual;

Dbms_metadata. GET_DDL (' tablespace ', ' PDA ')
--------------------------------------------------------------------------------

CREATE tablespace "PDA" datafile
'/DB_DATA/APP/ORACLE/ORADATA/PDA/PDA_01.DBF ' SIZE 2147483648
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL autoallocate SEGMENT SPACE MANAGEMENT AUTO

The solution of executing DBMS_METADATA.GET_DDL newspaper ORA-39212

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.