I got ” ORA-64308: hybrid columnar compressed table cannot have column with LONG data type” error in Oracle database during table creation.
ORA-64308: hybrid columnar compressed table cannot have column with LONG data type
Details of error are as follows.
ORA-64308: hybrid columnar compressed table cannot have column with LONG data type
The ORA-64308 error is related with the Create a hybrid columnar compressed table with a LONG data type or Alter an existing table with a LONG data type to be hybrid columnar compressed and also Add a LONG data type column to a hybrid columnar compressed table.
ORA-64308
To solve this error, you should create the new uncompressed ( HCC ) tablespace and try again.
If your tablespace is not compressed with the hybrid columnar compression, then you won’t get this error again.
If your tablespace is compressed with the Hybrid columnar compression and there is no possibility to create new uncompressed tablespace, then you shouldn’t use LONG data type.
If modifying attributes of a column to change data type to LONG, the table cannot be hybrid columnar compressed.
Because LONG data types are not supported with hybrid columnar compressed tables.