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