Oracle Database Errors or Warnings from Error ORA-36685 to ORA-36700


ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.
Cause: User attempted to define a RANGE or LIST partition template with one or more partitions dimensioned by another partition template.
Action: Use only regular dimensions and composites to dimension each partition of the RANGE or LIST template.
ORA-36686: (XSDPART24) Value number is not in partition number.
Cause: User attempted to reorganize a list partition template by removing a value from some partition’s list, but the value was not in the list.
Action: Ensure that the given values match the given partition.
ORA-36687: (XSDPART25) You cannot use compressed composite workspace object to dimension multiple partitions of the partition template, because its dimension list includes the PARTITION BY dimension workspace object.
Cause: The specified PARTITION BY dimension also occurred in the dimension list of a compressed composite used to dimension multiple partitions.
Action: Ensure that no PARTITION BY dimension occurs among the bases of the compressed composite used to dimension multiple partitions.

ORA-36688: (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
Cause: An unknown character set conversion error occurred when converting a TEXT value to an NTEXT value.
Action: Unknown.
ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
Cause: The user called the UNISTR function on a string that had an invalid escape sequence. The only valid escape sequences in UNISTR are 1.) an escape-escape sequence, and 2.) an escape, followed by exactly four hexadecimal digits.
Action: Make sure that all escape sequences in UNISTR arguments are exactly four hexadecimal digits. To represent codepoints whose value is less than 0x1000, use preceding zeros. WRONG: 0x10; RIGHT: 0x0010.
ORA-36692: (XSRELGID24) A level relation must be specified for the GROUPSET and ROLLUP options of GROUPINGID.
Cause: level relation was not specified.
Action: Specify a level relation.
ORA-36693: (XSRELGID25) INHIERARCHY cannot be specified with the GROUPSET and ROLLUP options of GROUPINGID.
Cause: INHIERARCHY option was specified.
Action: Remove INHIERARCHY option.

ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.
Cause: Unknown.
Action: Check the context and permission for dimension maintenance.
ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
Cause: An ineligible dimension was specified in the Qualified Data Reference
Action: Do not attempt to qualify this dimension.
ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
Cause: The named dimension was not in the relation’s dimension list.
Action: Select only dimensions that are in the relation’s dimension list.
ORA-36700: (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
Cause: The same dimension was specified more than once in the QDR.
Action: Specify each QDR dimension only once.

Above are list of Oracle Database Errors or Warnings from Error ORA-36685 to ORA-36700 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.

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 *