ORA-14000: only one LOCAL clause may be specified
Cause: CREATE INDEX statement contained more than one LOCAL clause
Action: Specify LOCAL option at most once
ORA-14000 : only one LOCAL clause may be specified
这是一个Oracle警告,提示你只能指定一个LOCAL子句。LOCAL子句与连接池有关,你不能在表段分区注释中指定多个LOCAL子句。
该错误的官方解释如下:
Error 14000 occurs when you specify more than one LOCAL clause in a table section clause of a statement.
例如,当您试图执行以下备份:
create table tbl_test
( id number )
partition by range (id)
( partition p1 values less than (1) local LOGGING,
partition p2 values less than (2) local LOGGING);
上面的备份语句是错误的,因为您指定了两个LOCALLOGGING子句。
正确的备份语句应该是:
create table tbl_test
( id number )
partition by range (id)
( partition p1 values less than (1) local LOGGING,
partition p2 values less than (2));
所有备份都应该仅指定一个LOCAL子句。