Oracle Database Errors or Warnings from Error ORA-14191 to ORA-14204

SQLServerF1

ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object
Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE/ALTER INDEX statement issued against a range-partitioned index which is illegal.
Action: Remove the illegal option. If it is desired to add storage to individual partitions, ALLOCATE STORAGE clause may be specified with ALTER TABLE/INDEX MODIFY PARTITION statement.
ORA-14192: cannot modify physical index attributes of a Hash index partition
Cause: User attempted to modify one of INITRANS/MAXTRANS/LOGGING/STORAGE clause for an index partition of a Hash partitioned index
Action: Remove the physical attributes one is trying to modify
ORA-14193: invalid ALTER INDEX MODIFY SUBPARTITION option
Cause: An option other than UNUSABLE, ALLOCATE EXTENT, DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY SUBPARTITION statement.
Action: Specify only legal options.

ORA-14194: only one subpartition may be rebuilt
Cause: ALTER INDEX REBUILD SUBPARTITION contained descriptions of more than one subpartition to be rebuilt
Action: Ensure that the statement describes exactly one subpartition to be rebuilt and that it does not contain any commas
ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE/ALTER INDEX statement issued against a range-partitioned index which is illegal.
Action: Remove the illegal option. If it is desired to add storage to individual partitions, ALLOCATE STORAGE clause may be specified with ALTER TABLE/INDEX MODIFY PARTITION statement.
ORA-14196: Specified index cannot be used to enforce the constraint.
Cause: The index specified to enforce the constraint is unsuitable for the purpose.
Action: Specify a suitable index or allow one to be built automatically.

ORA-14201: specified subpartition bound is too long
Cause: Length of a linear key representation of a high bound of a table subpartition being added or along which an existing table or index subpartition is being split exceeded the legal limit (4K).
Action: Change the representation of a subpartition high bound to bring its length within legal limit.
ORA-14202: subpartition bound of subpartition “string” is too high
Cause: High bound of the specified subpartition displayed in this message did not collate lower than that of the subsequent subpartition.
Action: Ensure that high bound of every subpartition (except for the last one) collates lower than that of a subsequent subpartition.
ORA-14203: subpartition bound of subpartition “string” is too long
Cause: Length of linear key representation of a high bound of the specified subpartition displayed in this message exceeded the legal limit (4K).
Action: Change the representation of a subpartition high bound to bring its length within legal limit.
ORA-14204: subpartition bound of subpartition number string is too high
Cause: High bound of the specified subpartition displayed in this message did not collate lower than that of the subsequent subpartition.
Action: Ensure that high bound of every subpartition (except for the last one) collates lower than that of a subsequent subpartition.

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