ORA-39728
A compressed table cannot have column with LONG data type.
Cause
One of the following was attempted:
- Created a basic or advanced row compressed table with a LONG data type.
- Altered an existing table with a LONG data type to be basic or advanced row compressed.
- Added a LONG data type column to a basic or advanced row-compressed table.
Action
LONG data types are not supported with basic or advanced row compressed tables. Create the table without a LONG column or change the table to not use basic or advanced row compression. If adding a column, do not use the LONG data type. If modifying attributes of a column to change the data type to LONG the table cannot be basic or advanced row compressed.