ORA-06512 get_ddl

来源：互联网发布：2016中国台湾贸易数据编辑：程序博客网时间：2024/06/14 13:59

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> select dbms_metadata.get_ddl('TABLE','OSM_DML_10','OSM_TAB_4') from dual
2 /
ERROR:
ORA-31603: object "OSM_DML_10" of type TABLE not found in schema "OSM_TAB_4"
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1901
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

no rows selected

在Metalink找的结果：
Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.0 to 9.2.0.8
This problem can occur on any platform.

Symptoms
Execution of dbms_metadata.get_ddl results in ORA-19206,ORA-6512

e.g.
SQL> select dbms_metadata.get_ddl('TABLE','TEST') from dual;
ERROR:
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-6512: at "SYS.DBMS_XMLGEN", line 83
ORA-6512: at "SYS.DBMS_METADATA", line 345
ORA-6512: at "SYS.DBMS_METADATA", line 410
ORA-6512: at "SYS.DBMS_METADATA", line 449
ORA-6512: at "SYS.DBMS_METADATA", line 615
ORA-6512: at "SYS.DBMS_METADATA", line 1221
ORA-6512: at line 1

Cause
This error may occur if either XML Database in not installed or has not been installed properly.

Solution
Reinstall XML Database (XDB)