Oracle Database Errors or Warnings from Error ORA-14759 to ORA-14801
ORA-14759: SET INTERVAL is not legal on this table.
Cause: ALTER TABLE SET INTERVAL is only legal on a range partitioned table with a single partitioning column. Additionally this table cannot have a maxvalue partition.
Action: Use SET INTERVAL only on a valid table
ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects
Cause: ALTER TABLE ADD PARTITION was attempted on an Interval partitioned object.
Action: Do not perform the operation on an Interval partitioned object. Insert a row to create the new partition.
ORA-14761: MAXVALUE partition cannot be specified for Interval partitioned objects
Cause: An attempt was made to create a partition with a MAXVALUE highbound on an Interval partitioned object.
Action: Do not create a partition with a MAXVALUE highbound.
ORA-14762: Domain index creation on interval partitioned tables is not permitted
Cause: An attempt was made to create a domain index on an interval partitioned table.
Action: Do not create a domain index on an interval partitioned table.
ORA-14763: Unable to resolve FOR VALUES clause to a partition number
Cause: Could not determine the partition corresponding to the FOR VALUES clause.
Action: Remove bind variables and dependencies on session parameters from the values specified in the FOR VALUES clause.
ORA-14764: FOR VALUES clause cannot be specified for only one partition
Cause: An attempt was made to specify the FOR VALUES clause for only one of the two partitions being merged.
Action: Specify a FOR VALUES clause for each of the two partitions being merged or do not specify the FOR VALUES clause for either.
ORA-14765: Cannot create a partition while doing a create index
Cause: An attempt was made to create a partition concurrently with index creation.
Action: Retry the statement after the index build is finished.
ORA-14766: Unable to obtain a stable metadata snapshot
Cause: This operation was not able to obtain a stable snapshot of the interval partitioning metadata.
Action: Retry the statement.
ORA-14767: Cannot specify this interval with existing high bounds
Cause: The interval specified conflicts with the existing high bound for the last partition. The combination might lead to invalid dates for high bounds in the future.
Action: If this is a CREATE TABLE, try specifying a different high bound value for the last partition, or a different interval. If this is an ALTER TABLE SET INTERVAL, please choose either a different interval, or, modify the table to change the high bound for the last partition.
ORA-14801: Hash composite partitioning is not supported
Cause: An attempt was made to partition a table using a Hash composite method.
Action: Do not partition the table by a Hash composite method.
Above are list of Oracle Database Errors or Warnings from Error ORA-14759 to ORA-14801 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.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.