Copying a LONG RAW column into another tablespace
How can I copy a table with a LONG RAW column from one into another tablespace? It´s important to know that it is not allowed to change the LONG RAW datatype.
First, dump the table's contents to a dump file:
exp userid=system/manager file=move.dmp tables=scott.empUse the correct table name above. Next, drop the table and recreate it in the correct tablespace. Once the table is recreated, import the dump file contents with the IGNORE=Y option.
imp userid=system/manager file=move.dmp tables=scott.emp ignore=y