Migrating User Data from One tablespace to another tablespace: Oracle 11g Rel 2

Hi Friends,

Recently I have come across a migration of Oracle User's data from one tablespace to another tablespace.

Following are the command that you can create with the help of dba_objects, dba_lobs, all_indexes and dba_users

Moving Table from One tablespace to another

Alter table owner.tablename move tablespace *new tablespace*

Moving Index from one tablespace to another

Alter index owner.indexname rebuild tablespace *new tablespace*

Moving Lob Objects from one tablespace to another

Alter table owner.tablename move lob (columnname) store as (tablespace *new tablespace*)

Please comment if it worked for you during your support.