Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Moving table to another tablespace. Table has long raw datatype

user128148Feb 9 2010 — edited Feb 10 2010
Hello,

I am attempting to move a table to another tablespace. This table has a long raw datatype. So I am using 'alter table table_name move tablespace new_tablespace_name' but this statement does not work because the table has a column that is of datatype 'long raw'.

The database is 10v2 and I am thinking of exporting the table and then import it using the option remap_tablespace. Would this work even though the table has long raw datatype? Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2010
Added on Feb 9 2010
8 comments
6,731 views