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!

move table from one TS to another TS

546111Apr 1 2007 — edited Apr 1 2007
i want to move one of my table from tablespace A to tablespace USERS. But one column of that table contains cLOB datatype.if i issue the following command
SQL>alter table table_name move tablespace users;
will the above statement move the table to the tablespace users.
thankx...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2007
Added on Apr 1 2007
6 comments
760 views