Oracle Database Errors or Warnings from Error ORA-36664 to ORA-36673

SQLServerF1

ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
Cause: User tried to define a PARTITION TEMPLATE without a PARTITION BY clause.
Action: Add a PARTITION BY clause.
ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
Cause: While defining a partition template, user attempted to specify a partition dimension that is not a dimension of the partition template itself.
Action: Choose a partition dimension from among the dimensions of the partition template.
ORA-36666: (XSDPART04) workspace object is not a concat dimension.
Cause: User tried to define a partition template with PARTITION BY CONCAT(… dim …) where dim is not a concat dimension.
Action: Only concat dimensions can serve as partition dimensions with CONCAT partitioning. Choose a different partition dimension.

ORA-36667: (XSDPART05) string is not a legal CONCAT partition.
Cause: User attempted to use RANGE or LIST syntax in defining a CONCAT partition template.
Action: Use CONCAT partition syntax.
ORA-36668: (XSDPART06) string is not a legal RANGE partition.
Cause: User attempted to use CONCAT or LIST syntax in defining a RANGE partition template.
Action: Use RANGE partition syntax.
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.

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.
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.
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.
ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the <LEAF: VALUE> 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 <LEAF: VALUE> format of a concat dimension value.
Action: Use just the leaf value. Instead of “VALUES LESS THAN <leaf: value>”, just say, “VALUES LESS THAN value”.

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