ORA-14175: a subpartition maintenance operation may not be combined with other operations

ORA-14175: a subpartition maintenance operation may not be combined with other operations

Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a subpartition maintenance operation (e.g. MOVE SUBPARTITION) with some other operation (e.g. MODIFY PARTITION ADD SUBPARTITION or PCTFREE) which is illegal

Action: Ensure that a subpartition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with subpartitions, default attributes of partitioned tables or indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will

ORA-14174: only a lamp;lt;lamp;nbsp;parallel clauselamp;gt; may follow COALESCE PARTITION|SUBPARTITION

ORA-14174: only a lamp;lt;lamp;nbsp;parallel clauselamp;gt; may follow COALESCE PARTITION|SUBPARTITION

Cause: ALTER TABLE COALESCE PARTITION|SUBPARTITION may be followed by an optional lamp;lt;lamp;nbsp;parallel clauselamp;gt;. No partition or subpartition attributes may be specified

Action: Ensure that no partition or subpartition attribute was specified.

ORA-14173: illegal subpartition-extended table name syntax

ORA-14173: illegal subpartition-extended table name syntax

Cause: Subpartition to be accessed may only be specified using its name. User attempted to use a subpartition number or a bind variable.

Action: Modify statement to refer to a subpartition using its name

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

Cause: Name of the table to be EXCHANGED has to be followed by ({INCLUDING|EXCLUDING} INDEX(({WITH|WITHOUT} VALIDATION(

Action: Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE SUBPARTITION

ORA-14171: cannot specify lamp;lt;lamp;nbsp;subpartition-descriptionlamp;gt; clause in CREATE|ALTER TABLE

ORA-14171: cannot specify lamp;lt;lamp;nbsp;subpartition-descriptionlamp;gt; clause in CREATE|ALTER TABLE

Cause: User requested to generate default subpartition description(s) (possibly via SUBPARTITIONS) while at the same time specified lamp;lt;lamp;nbsp;subpartition-descriptionlamp;gt; clause which is illegal

Action: Remove one of offending clauses.

ORA-14170: cannot specify lamp;lt;lamp;nbsp;partition-descriptionlamp;gt; clause in CREATE TABLE|INDEX

ORA-14170: cannot specify lamp;lt;lamp;nbsp;partition-descriptionlamp;gt; clause in CREATE TABLE|INDEX

Cause: User requested to generate default partition description(s) (possibly via PARTITIONS lamp;lt;lamp;nbsp;number-of-partitionslamp;gt;) while at the same time specified lamp;lt;lamp;nbsp;partition-descriptionlamp;gt; clause which is illegal

Action: Remove one of offending clauses.

ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option

ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option

Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, was specified in an ALTER TABLE MODIFY SUBPARTITION statement.

Action: Specify only legal options.