重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-37418: detail query cannot be derived [打印本页]

作者: michaeljet 时间: 2016-9-7 10:40
标题: ORA-37418: detail query cannot be derived

Cause: If an ORANIZATION CUBE MV isto automatically derive its loading

clause, then its definition query cannot contain setoperators (eg UNION ALL), a

HAVING clause, START WITH or a SQL MODEL clause. Thedefinition query

contains these or other unsupported syntax.

Action: Use an explicit ORGANIZATIONCUBE clause, or simplify the defining

query.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)