1)
SQL> conn scott/scott
Connected.
SQL> select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') 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 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
解决:切换到sysdba下,exec dbms_metadata_util.load_stylesheets;
2)
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;该语句中函数的参数如果不大写,会报错:
ERROR:
ORA-31600: invalid input value table for parameter OBJECT_TYPE in function
GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2681
ORA-06512: at "SYS.DBMS_METADATA", line 2732
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
解决:参数全部大写
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27009266/viewspace-742302/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27009266/viewspace-742302/