How to move table to another tablespace when the table contains a LONG RAW column?

Hi

I'm organizing tables into different tablespaces, and have been using 'ALTER TABLE <table_name> MOVE TABLESPACE <new Tablespace>'.

This works fine for most tables, but for those containing a LONG_RAW column, it does not (ORA-00997: illegal use of LONG datatype).

Is there a quick way to move these?

I know i can rename the old, create a new table, and move data with some application, but that is a pretty large job.

My problem involves about 20 tables, and I will probably do this to several databases.

Knut Received on Tue Apr 23 2002 - 05:02:10 CDT