moving a table to another tbs

[dba_45]

Hi

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.


Thanks

[Bore]

Please be more specific. What exactly you do to move the table?

[dba_45]

Hi

thanks for your reply.

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.

Regards

[Bore]

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

Regards

[dba_45]

Thanks bore

I will just check up the metalink and try the same. Thanks a lot

Regards

[r_tanawade]

mvove table tablename to tablespace

[Bore]

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".

Regards

It is maybe a good idea to read the thread before posting dummy posts

Regards