move tablespace command fails on two types of cases

Case 1:

alter table XTABLE move tablespace YTABLESPACE *
ERROR at line 1:
ORA-00997: illegal use of LONG datatyp

Case 2:

alter table ZTABLE move tablespace YTABLESPACE

            *
ERROR at line 1:
ORA-14511: cannot perform operation on a partitioned object

The long is storing a string type

I'm not clear on what a partitioned object is and how to tell and why it became partitioned.

Bob Received on Mon Jun 16 2003 - 19:36:10 CDT