How to move table with long objects?

I would like to move a table with a long object to another tablespace. I use Oracle 8.1.6.

I tried

"alter table XY move tablespace AB"
and

"alter table XY move tablespace AB lob (LOB_COLUMN_NAME) store
as ( tablespace AB )"

but everytime I get the error "ORA-00997: Illegal use of LONG datatype".

Any idea ??? Received on Fri Apr 27 2001 - 06:02:57 CDT