Oracle Database Errors or Warnings from Error ORA-36674 to ORA-36684

SQLServerF1

ORA-36674: (XSDPART12) Invalid dimension value starting at string.
Cause: When defining a RANGE or LIST partition template, the user specified an invalid value in a VALUES LESS THAN or VALUES clause. An “invalid value” can be one of two things: a value whose datatype does not match the partition dimension’s datatype, or a non-constant value.
Action: Modify the offending VALUES LESS THAN or VALUES phrase.
ORA-36676: (XSDPART14) Missing dimension list for string.
Cause: User attempted to define a CONCAT partition template, and didn’t supply a list of dimensions for one of the partition definitions.
Action: Give a dimension list for each partition.
ORA-36677: (XSDPART15) Duplicate value in value lists of number and number
Cause: In a LIST PARTITION TEMPLATE definition, a value appeared in more than one value list, or more than once within a single value list.
Action: List each value only once.

ORA-36678: (XSDPART16) workspace object is missing from one or more partition dimension lists.
Cause: In the definition of a partition template, one of the partitions had a dimension list that did not contain all the dimensions of the partition template.
Action: Add the offending dimension to the partition’s dimension list, or delete it from the partition template’s dimension list. If using CONCAT partitioning and the missing dimension is a partition dimension, add to the partition dimension list any leaf of the partition dimension or any concat of leaves of the partition dimension.
ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
Cause: In the definition of a CONCAT partition template, one of the partitions was dimensioned by a dimension that is “concat-related” to a partition dimension, meaning it shares some leaves with the partition dimension, but it contained some leaves that are not in the partition dimension.
Action: Either modify the dimensionality of the partition template to include a concat dimension that contains all the desired leaves, or pick a different dimension for the partition.
ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
Cause: In the definition of a partition template, one of the partitions was dimensioned by a dimension that was not given in the dimension list of the partition template.
Action: Remove the offending dimension from the partition’s dimension list, or add it to the partition template’s dimension list.

ORA-36681: (XSDPART19) Partitions string and string are out of order.
Cause: In the definition of a range partition template, a partition with a lower range boundary was listed after a partition with a higher range boundary.
Action: Alter the order of the partition definition list.
ORA-36682: (XSDPART20) Partition name string appears twice.
Cause: User gave a list of AW partitions in which some partition name appeared twice.
Action: Remove all but the first instance of the partition name from the list.
ORA-36683: (XSDPART21) Partition string dimensioned by more than one composite.
Cause: It is illegal to define a partition template in which one of the partitions is dimensioned by more than one composite.
Action: Make sure that the partition template being defined has at most one composite per partition.
ORA-36684: (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
Cause: User attempted to rename a value of a dimension that serves as the partition dimension of some RANGE or LIST partition template.
Action: It is not possible to rename values in such a dimension without deleting all RANGE and LIST partition templates that are partitioned by it.

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

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase 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 *