ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified
Cause: RECOVERABLE was specified more than once, UNRECOVERABLE was specified more than once, or both RECOVERABLE and UNRECOVERABLE were specified in a CREATE TABLE or CREATE INDEX or ALTER INDEX REBUILD statement.
Action: Remove all but one of the RECOVERABLE or UNRECOVERABLE clauses and reissue the statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-01783：只能指定一个RECOVERABLE或UNRECOVERABLE子句,
.原因： RECOVERABLE被多次指定，UNRECOVERABLE被指定了多次，或者在CREATE TABLE或CREATE INDEX或ALTER INDEX REBUILD语句中指定了RECOVERABLE和UNRECOVERABLE。,
.操作：删除RECOVERABLE或UNRECOVERABLE子句中除了一个之外的所有子句，然后重新发出该语句。,
.

aiaiDBA

13718043309

010-86462881

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

1 个回答

相似问题