当前位置:首页 > 网络编程 > 数据库 > Oracle > ORA-06512 get_ddl

ORA-06512 get_ddl

点击次数:40 次 发布日期:2008-11-22 16:28:51 作者:源代码网
源代码网推荐

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)

源代码网供稿.
网友评论 (0)
会员中心
网络编程
本站推荐
网络编程之精华