Tag Archives: ORA-60001 to ORA-64307

ORA-64307: hybrid columnar compression is only supported in tablespaces residing on Exadata storage

This is a quick solution for Oracle error ORA-64307. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64300: Invalid compression level specified

In this article you will be presented a brief description for error ORA-64300.

ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.

In htis article you will fine a solution for error: An attempt was made to convert CLOB to CHAR, where the LOB size was bigger than the buffer limit for CHAR types or the CHAR buffer was not big enough to hold all data after character set conversion.. This solution is suitable for Oracle 11g Release 2 (11.2).

ORA-64202: remote temporary or abstract LOB locator is encountered

In this article you will be presented a brief description for error ORA-64202.

ORA-64201: unregistered LOB value encountered

This is a brief information taken from Oracle documentation, where you can find a proposed solution for Oracle error: ORA-64201. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64144: Shared tables must have equivalent paths.

This is a quick solution for Oracle error ORA-64144. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column.

This is the solution suitable for Oracle 11g Release 2 (11.2) for the following problem:An attempt was made to share a table without an XMLTYPE column.

ORA-64142: Shared tables must have same semantics for truncation.

If the following problem occurs in your application read this article: An attempt was made to create shared tables with inconsistent semantics for truncation. Either all shared tables should have or should not have (TRUNCATE) keyword.

ORA-64141: Can only have a single XMLType column when a table is shared.

In htis article you will fine a solution for error: An attempt was made to create a shared table with more than one columns.. This solution is suitable for Oracle 11g Release 2 (11.2).

ORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index

This is a brief information taken from Oracle documentation, where you can find a proposed solution for Oracle error: ORA-64140. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64139: The type of VIRTUAL column is not XMLTYPE

If the following problem occurs in your application read this article: An attempt was made to create an XML index with VIRTUAL column not of XMLTYPE.

ORA-64138: Cannot drop groups from an XMLIndex whose internal table has been indexed using Oracle Text.

This is the solution for the following problem:An attempt was made to drop groups from an XMLIndex whose internal table has been indexed using Oracle Text.

ORA-64137: Cannot drop an XMLIndex whose internal table has been indexed using Oracle Text.

This is a short information taken from Oracle documentation where you can find a proposed solution for Oracle error: ORA-64137. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64136: XMLIndex Asynchronous DML: synchronization failure

This is a quick solution for Oracle error ORA-64136. This solution is suitable for Oracle 11g Release 2 (11.2). If you are interested please come in.

ORA-64135: XMLIndex DML: failure of a recursive DML

This is the solution for the following problem:See associated error message.