How to move table containing LONG or LOB columns?

Today a friend of mine asked me how to move a table having LONG datatype.As per him, when he fired alter table table_name move tablespace , he got "ORA-00997: illegal use of LONG datatype".In past, i had moved the tables to the other tablespace but had not faced this error.So, it was time to do … Continue reading How to move table containing LONG or LOB columns?

Advertisement