Oracle Database Errors or Warnings from Error ORA-14020 to ORA-14029

SQLServerF1

ORA-14020: this physical attribute may not be specified for a table partition
Cause: unexpected option was encountered while parsing physical attributes of a table partition; valid options for Range or Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, and PCTUSED; only TABLESPACE may be specified for Hash partitions
Action: remove invalid option(s) from the list of physical attributes of a table partition
ORA-14021: MAXVALUE must be specified for all columns
Cause: In the VALUES LESS THAN clause for the highest (last) partition of a GLOBAL index, MAXVALUE must be specified for all columns
Action: Ensure that VALUES LESS THAN clause for the last partition of a GLOBAL index has MAXVALUE specified for all columns
ORA-14022: creation of LOCAL partitioned cluster indices is not supported
Cause: An attempt was made to create a LOCAL partitioned cluster index, which is currently illegal
Action: Remove LOCAL along with <partition description>s, if any, from the CREATE INDEX statement.

ORA-14023: creation of GLOBAL partitioned cluster indices is not supported
Cause: An attempt was made to create a GLOBAL partitioned cluster index, which is currently illegal
Action: Remove PARTITION BY RANGE clause along with <partition description>s from the CREATE INDEX statement.
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
Cause: User attempted to create a LOCAL partitioned index with a number of partitions which is different from that of the underlying table.
Action: Correct the CREATE INDEX statement to specify a correct number of partitions
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

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-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-14028: missing AT or VALUES keyword
Cause: keyword AT or VALUES missing
Action: supply missing keyword
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

Above are list of Oracle Database Errors or Warnings from Error ORA-14020 to ORA-14029 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *