We have a user table which is lying in system tbs and there is only one field in that and its type is LONG. Now when we try to move the table to some other tbs i am geting ora-00997 illegal use of long type. . can any one help us to move the table to the respective tbs.
In 2005 my predecessor by mistake created a table in system tablespace which has only one field and the field type is LONG. now i am trying to move the table to another tablespace by
" alter table table_name move tablespace tablespace_name " .
When i execute the above command i am getting the following error
" ora-00997 illegal use of long type".
Can you tell me how to move a table having field type LONG to another tablespace.
Metalink Note:147356.1 says:
"The drawback to using
this method is the you cannot move a table with a LONG or LONG RAW. You
must exp that table and imp it into a table. You can do this easily by
exporting the table with the LONG/LONG RAW, dropping that table
-- creating an empty version of this table in the new tablespace and
importing just that table."
Metalink Note:1012307.6 explains how to move table using exp/imp