ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
Cause: CREATE TABLE/INDEX statement used to create a partitioned table/index contained RECOVERABLE or UNRECOVERABLE clause which is illegal
Action: Remove offending clause. [UN]RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

可能不能为分区表/索引指定ORA-14104：RECOVERABLE / UNRECOVERABLE,
.原因：用于创建分区表/索引的CREATE TABLE / INDEX语句包含RECOVERABLE或UNRECOVERABLE子句，这是非法的,
.操作：删除违规子句。[UN] RECOVERABLE在V8中被弃用，在V9中将被废弃。要复制UNRECOVERABLE子句的语义，使用NOLOGGING选项创建一个对象，然后ALTER它指定LOGGING。要复制RECOVERABLE子句的语义，使用LOGGING选项创建一个对象。,
.

aiaiDBA

13718043309

010-86462881

ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 个回答

相似问题