文档解释 ORA-32307: must use FROM ONLY clause when referencing an object table Cause: An attempt was made to create a materi
ORA-32307: must use FROM ONLY clause when referencing an object table
Cause: An attempt was made to create a materialized view whose definition query references object tables without the FROM ONLY clause.
Action: Rewrite the definition query to use the FROM ONLY clause for all the object tables in the query.
ORA-32307: 引用对象表时必须使用from only子句
ORA-32307表明,在引用对象表时必须使用from only子句。当查询涉及存储在对象表中的复杂嵌套对象类型时,这是必要的。
一个常见的用于发生这个错误的情况是,当程序试图从一个对象表中返回基元类型属性而不使用from only子句时。
避免凡是从一个对象表中返回基元类型属性时,必须使用from only子句。
正确示例:
select emp_name, emp_address
from employees table(from only)
where emp_id = ‘10012’;
--结束END--
本文标题: ORA-32307: must use FROM ONLY clause when referencing an object table ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/532030.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0