I am currently migrating all the tables in my database to a bigfile tablespace. I have written a script to do this and all tables are migrated successfully except one. I am given the error:
Error report: SQL Error: ORA-00997: illegal use of LONG datatype 00997. 00000 - "illegal use of LONG datatype"
And I am converting the tablespaces by:
alter table mytable move tablespace bigfile_tablespace;
Changing the column type isn't an option.
I have a script that creates all the tablespace from scratch using bigfile and it goes through fine with this table so I am little stuck on this...