* Make the LOB smaller before performing the conversion. for example, by using SUBSTR on CLOB
* Use DBMS_LOB.SUBSTR to convert CLOB to CHAR.
- 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.