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