ora-凯发app官方网站

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)

阅读(3006) | 评论(0) | 转发(0) |

上一篇：排序和统计（sort, uniq）

下一篇：学习－－如何提升你的沟通技巧

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们