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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the  format

Cause: When defining a RANGE partition template with a concat dimension for the partition dimension, the user attempted to define a range using the  format of a concat dimension value

Action: Use just the leaf value. Instead of "VALUES LESS THAN ", just say, "VALUES LESS THAN value"

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension

Cause: User attempted to define a RANGE or LIST partition template with more than one partition dimension

Action: Remove all but one of the dimensions from the PARTITION BY RANGE(...) or PARTITION BY LIST(...) clause of the partition template definition

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used

Cause: User attempted to define a range partition template with a concat partition dimension, and the concat had two leaf dimensions with different datatypes

Action: Pick a different partition dimension

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36670: (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions

Cause: User attempted to define a partition template partitioned by an INTEGER or NTEXT dimension or a concat containing an NTEXT leaf

Action: Either pick a different partition dimension, or redefine the dimension to use a different datatype

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36669: (XSDPART07) string is not a legal LIST partition

Cause: User attempted to use RANGE or CONCAT syntax in defining a LIST partition template

Action: Use LIST partition syntax

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/