Move tablespace

[DontBShy]

Hi,

I want to know how change the tablespace of a table which contains longraws or blob datatype??

Wtih Alter table ... move tablespace i got an error of illegal use of long datatype.

Thanks

[jrpm]

I would export the table, create a clone in the new tablespace, drop the old then import the data.

Or, copy the table to a new table in the new tablespace, then drop the old table and rename the new.

I believe both the COPY command and the export/import utilities are about the only way to deal with RAW and BLOBS.