Team,
I am trying to change the datatype size from varchar2 to CLOB as my incomming data is more than 4000 BYTES.
But below statemnt is giving error.
EARLIER it was VARCHAR2(3500 BYTES);
alter table CUSTOMER
modify transaction_date CLOB ; -- Not working ..Please suggesr
Error report:
SQL Error: ORA-22858: invalid alteration of datatype
22858. 00000 - "invalid alteration of datatype"
*Cause: An attempt was made to modify the column type to object, REF,
nested table, VARRAY or LOB type.
*Action: Create a new column of the desired type and copy the current
column data to the new type using the appropriate type
constructor