在开发库rhel5 oracle10.2.0.4上执行dbms_metadata.get_ddl报错ORA-39212

SQL> select dbms_metadata.get_ddl('TABLESPACE','SYSTEM') 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 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 1920
ORA-06512: at "SYS.DBMS_METADATA", line 2793
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

 

no rows selected

SQL> select dbms_metadata.get_ddl('TABLESPACE','TEST') from dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLResetAllVars in routine
kuxslResetParams:
LPX-1: NULL pointer
ORA-06512: at "SYS.UTL_XML", line 288
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7541
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9495
ORA-06512: at "SYS.DBMS_METADATA", line 1920
ORA-06512: at "SYS.DBMS_METADATA", line 2793
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

 

-bash-3.2$ oerr ora 39212
39212, 00000, "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 table
//          "sys.metastylesheet." Either the stylesheets were not loaded
//          at all, or they were not converted to the database character
//          set.
// *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets
//          to reload the stylesheets.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-666229/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-666229/