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

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.

 

 

Do you want to learn Hybrid Columnar Compression, then Click This Link and read the articles.

Hybrid Columnar Compression ( HCC ) in Oracle Exadata -1