Oracle Error Message
ORA-64308: hybrid columnar compressed table cannot have column with LONG data type
Reason for the Error
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.
Solution
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.
