ALTER TABLE APPFLAG MOVE TABLESPACE PAY_DATA
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
I have one table which has a LONG datatype, i have to move this table to another tablespace.
the sourcedb was using system tablespace but in targetdb we need to use pay_data tablespace.
i have managed to move all the other tables however i have the above error with this one table.
how can i solve this.
there are data in this table therefore i will not be able to create it again.