Saturday, July 16, 2011

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.

No comments:

Post a Comment