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
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments