How to fix the Oracle error ORA-64308: hybrid columnar compressed table cannot have column with LONG data type?

In this post, you’ll learn more about the Oracle ErrorORA-64308: hybrid columnar compressed table cannot have column with LONG data type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-64308: hybrid columnar compressed table cannot have column with LONG data type

Reason for the Error ORA-64308: hybrid columnar compressed table cannot have column with LONG data type

One of the following was attempted:

– Create a hybrid columnar compressed table with a LONG data type.

– Alter an existing table with a LONG data type to be hybrid columnar compressed.

– Add a LONG data type column to a hybrid columnar compressed table.

How to fix the Error ORA-64308: hybrid columnar compressed table cannot have column with LONG data type ?

You can fix this error in Oracle by following the below steps

LONG data types are not supported with hybrid columnar compressed tables. Create table without LONG column or change table to not be hybrid columnar compressed. If adding a column, do not use LONG data type. If modifying attributes of a column to change data type to LONG, the table cannot be hybrid columnar compressed.