Q
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.emp
Use 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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close