How to move table along with clob into another tablespace

How to move table along with clob into another tablespace

 

  

Dear All,



Move table_name tablespace_src tablespace_dest



Moving table to destination tablespace, but if any clob pointing to source is not moving to destination. So that, I am creating a dummy table in destination tablespace, loading data, dropping original and renaming dummy.



Is there any possibility clob destination also along with table?



Regards,

Sree



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

Oracle LazyDBA home page