Tuesday, 13 March 2012

ORA-14031: partitioning column may not be of type LONG or LONG RAW

ORA-14031: partitioning column may not be of type LONG or LONG RAW

Cause: Partitioning column specified by the user was of type LONG or LONG RAW, which is illegal.

Action: Ensure that no partitioning column is of type LONG or LONG RAW.

ORA-14030: non-existent partitioning column in CREATE TABLE statement

ORA-14030: non-existent partitioning column in CREATE TABLE statement

Cause: Partitioning column specified in CREATE TABLE statement is not one of columns of the table being created.

Action: Ensure that all columns in the partitioning column list are columns of the table being created.

ORA-14029: GLOBAL partitioned index must be prefixed

ORA-14029: GLOBAL partitioned index must be prefixed

Cause: partitioning columns of a global partitioned index must form a prefix of the index key columns

Action: Ensure that the GLOBAL partitioned index being created is prefixed

ORA-14028: missing AT or VALUES keyword

ORA-14028: missing AT or VALUES keyword

Cause: keyword AT or VALUES missing

Action: supply missing keyword

ORA-14027: only one PARTITION clause may be specified

ORA-14027: only one PARTITION clause may be specified

Cause: CREATE TABLE statement contained more than one PARTITION clause

Action: Specify PARTITION option at most once

ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

Cause: definition of a table contained both PARTITION and CLUSTER clauses which is illegal

Action: Remove one of the conflicting clauses

ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

Cause: PARTITION option was encountered while parsing a definition of a materialized view or a materialized view log

Action: Ensure that a definition of a MATERIALIZED VIEW does not include invalid options