Oracle - 创建物化视图

发布于 2024-12-21 16:30:50 字数 360 浏览 1 评论 0原文

我正在阅读一些文章，甚至堆栈上的一些答案，但我仍然有一些问题。我将发布我的 MV 代码以进行可能的分析：

CREATE MATERIALIZED VIEW some_materialized_view
REFRESH COMPLETE
START WITH sysdate
NEXT '2011-12-01' + 31
WIDTH PRIMARY KEY
AS my_query

错误是：

00984. 00000 -  "column not allowed here"

我忘记了什么吗？我唯一想要的就是我的MV每个月开始更新。有人可以帮忙吗？

谢谢！

原文

I'm reading some articles, even some answers here on stack, but i still have some issues. I'll post my MV code for possible analysis:

CREATE MATERIALIZED VIEW some_materialized_view
REFRESH COMPLETE
START WITH sysdate
NEXT '2011-12-01' + 31
WIDTH PRIMARY KEY
AS my_query

The error is:

00984. 00000 -  "column not allowed here"

Am i forgeting something? The only thing i want is that my MV update every month beggining. Can someone help?

Thanks!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

情愿 2024-12-28 16:30:50

您的命令中有两个语法错误。

子句 WIDTH PRIMARY KEY 应该是 WITH PRIMARY KEY （WITH 上有拼写错误）

NEXT 子句是使用需要 date 关键字的日期文字：

NEXT DATE '2011-12-01' + 31。

所以完整的命令应该是：

CREATE MATERIALIZED VIEW some_materialized_view
REFRESH
  COMPLETE
  START WITH SYSDATE
  NEXT DATE '2011-12-01' + 31
  WITH PRIMARY KEY
AS <your query here>

There are two syntax errors in your command.

The clause WIDTH PRIMARY KEY should be WITH PRIMARY KEY (you have a typo on WITH)

The NEXT clause is using a date literal which requires the date keyword:

NEXT DATE '2011-12-01' + 31.

So the full command should be:

CREATE MATERIALIZED VIEW some_materialized_view
REFRESH
  COMPLETE
  START WITH SYSDATE
  NEXT DATE '2011-12-01' + 31
  WITH PRIMARY KEY
AS <your query here>

回复收藏 0 原文