Oracle Database Errors or Warnings from Error ORA-14141 to ORA-14156

SQLServerF1

ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations
Cause: ALTER INDEX statement attempted to combine a VISIBLE|INVISIBLE operation with some other operation which is illegal
Action: Ensure that VISIBLE|INVISIBLE operation is the sole operation specified in ALTER INDEX statement
ORA-14142: ALTER INDEX VISIBLE|INVISIBLE may not be used with certain types of index
Cause: Using the ALTER INDEX VISIBLE|INVISIBLE statement on certain types of indexes (IOT-TOP, Cluster indexes) is illegal.
Action: Remove the option VISIBLE|INVISIBLE.
ORA-14143: CREATE INDEX INVISIBLE may not be used with this type of index
Cause: Certain types of indexes (IOT-TOP, Cluster indexes) cannot be created invisible.
Action: Remove the option INVISIBLE

ORA-14150: missing SUBPARTITION keyword
Cause: keyword SUBPARTITION missing
Action: supply missing keyword
ORA-14151: invalid table partitioning method
Cause: Invalid partitioning method was specified in CREATE TABLE statement. A table may be partitioned by RANGE, HASH, LIST, SYSTEM, or Composite Range-Hash/List/Range (R+H/L/R).
Action: Specify one of valid partitioning methods
ORA-14152: invalid number of partitions specified in PARTITIONS clause
Cause: number-of-partitions clause contained in CREATE TABLE or CREATE INDEX statement specified a number of partitions outside of legal range (1-1048575)
Action: Specify a number between 1 and 1024K-1 in the number-of-partitions clause

ORA-14153: only one of STORE IN or <partition-description> clause may be specified
Cause: both STORE IN and <partition-description> clauses were specified in a CREATE TABLE|INDEX command
Action: Remove one of offending clauses
ORA-14154: only one of STORE IN or <subpartition-description> clause may be specified
Cause: both STORE IN and <subpartition-description> clauses were specified in a CREATE TABLE|INDEX, or ALTER TABLE ADD|SPLIT PARTITION or ALTER TABLE MERGE PARTITIONS command for a Composite Range partitioned object
Action: Remove one of offending clauses
ORA-14155: missing PARTITION or SUBPARTITION keyword
Cause: expect either PARTITION or SUBPARTITION keyword but none was supplied
Action: supply missing keyword
ORA-14156: invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
Cause: number-of-subpartitions clause contained in CREATE TABLE or CREATE INDEX statement specified a number of subpartitions outside of legal range (1-1048575)
Action: Specify a number between 1 and 1024K-1 in the number-of-subpartitions clause

Above are list of Oracle Database Errors or Warnings from Error ORA-14141 to ORA-14156 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 *