Category Archives: ORA Database Error Messages

ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string

oracle

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

Back to previous menu

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

ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT

oracle

ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT
Cause: An unknown character set conversion error occurred when converting an NTEXT value to a TEXT value
Action: Unknown

Back to previous menu

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

ORA-36688: (NTEXTCNV00) Error during conversion from TEXT to NTEXT

oracle

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

Back to previous menu

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

ORA-36686: (XSDPART24) Value number is not in partition number

oracle

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

Back to previous menu

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

ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned

oracle

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

Back to previous menu

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

ORA-36684: (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object

oracle

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

Back to previous menu

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

ORA-36683: (XSDPART21) Partition string dimensioned by more than one composite

oracle

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

Back to previous menu

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

ORA-36682: (XSDPART20) Partition name string appears twice

oracle

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

Back to previous menu

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

ORA-36681: (XSDPART19) Partitions string and string are out of order

oracle

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

Back to previous menu

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

ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE

oracle

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

Back to previous menu

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