ORA-12814: only one CACHE or NOCACHE clause may be specified

ORA-12814: only one CACHE or NOCACHE clause may be specified
Cause: CACHE was specified more than once, NOCACHE was specified more than once, or both CACHE and NOCACHE were specified in a CREATE TABLE or CLUSTER, or in an ALTER TABLE or CLUSTER statement.
Action: Remove all but one of the CACHE or NOCACHE clauses and reissue the statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12814：只能指定一个CACHE或NOCACHE子句,
.原因：在CREATE TABLE或CLUSTER中或在ALTER TABLE或CLUSTER语句中指定了多次CACHE，多次指定NOCACHE或指定了多个CACHE和NOCACHE。,
.操作：删除除一个CACHE或NOCACHE子句之外的所有内容，然后重新发出语句。,
.

aiaiDBA

13718043309

010-86462881

ORA-12814: only one CACHE or NOCACHE clause may be specified

1 个回答

相似问题