Problem solve
Get help with specific problems with your technologies, process and projects.
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.
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.
Since you are using the LONG RAW datatype, your only option to move the table to another tablespace is to use the export and import utilities.
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
Start the conversation
0 comments