在Oracle上创建可编辑的视图 [英] Create editionable view on Oracle

问题描述

我正在尝试创建ORACLE EDITIONABLE VIEW，但出现错误:

I am trying to create an ORACLE EDITIONABLE VIEW but I am getting the error:

SQL错误:ORA-00922:缺少或无效的选项 00922. 00000-选项缺失或无效"

SQL Error: ORA-00922: missing or invalid option 00922. 00000 - "missing or invalid option"

 CREATE OR REPLACE FORCE EDITIONABLE VIEW "SCHEMA"."TABLE" ....

在 https://docs.oracle.com/database/提到了121/SQLRF/statements_8004.htm#SQLRF01504 您如何创建这种视图.

In https://docs.oracle.com/database/121/SQLRF/statements_8004.htm#SQLRF01504 is mentioned how u can create this kind of view.

如果我删除了EDITIONABLE，则视图创建成功.

If I remove EDITIONABLE the view is created without a problem.

我们欢迎您提出一些建议:-)

Some advice will be welcomed :-)

推荐答案

语法错误prbly

CREATE EDITIONING VIEW

您需要oracle 11gR2或更高版本

You need oracle 11gR2 or higher

还需要为用户启用版本:(来自这里)

Also you need to enable Editions for user: (from here)

使用ALTER USER命令为用户启用版本. 这是不可逆的.通过查询DBA_USERS视图的EDITIONS_ENABLED列可以看到此命令的结果.

Enabling editions for a user is done using the ALTER USER command. This is not reversible. The result of this command can be seen by querying the EDITIONS_ENABLED column of the DBA_USERS view.

CONN / AS SYSDBA

ALTER USER edition_test ENABLE EDITIONS;

这篇关于在Oracle上创建可编辑的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！