Online Move In 12c

Online Move in 12c

------------------

Datafile can be moved online from one storage to another storage.

Benefits:-

1) No need to offline the tablespace / datafile.

2) Select / DML and DDL operation supported during move.

3) Useful for moving datafiles from file system to ASM.

4) ADO benefited from the feature.

      a) Its transparently move the inactive data to inexpensive storage as required.

      b) Move the datafiles to highly compressed storage. ADO compression action will be benfited.

SQL> alter database move datafile '/u01/app/oracle/oradata/purchase/read_only01.dbf' to '/oracle/purchase_arch_data/read_only01.dbf';

Database altered.

SQL> ! ls -lrt /u01/app/oracle/oradata/purchase/read_only01.dbf

ls: /u01/app/oracle/oradata/purchase/read_only01.dbf: No such file or directory

SQL> ! ls -lrt /oracle/purchase_arch_data/read_only01.dbf

-rw-r----- 1 oracle oinstall 104865792 Aug 27 17:35 /oracle/purchase_arch_data/read_only01.dbf

SQL> alter database move datafile '/u01/app/oracle/oradata/purchase/system01.dbf' to '/oracle/purchase_arch_data/system01.dbf';

Database altered.

Move Partitions Online

1  1) Can move the partition / sub partition from one storage to another storage        online.

2  2) ILM benefits as the inactive partitions can be move from expensive storage to    inexpensive storage online  Compress time based partitions or sub partitions according to the ADO polices configured.

A  3) Alter table move partitions online will benefit the ADO polices to move the partitions to another inexpensive storage / or high compressed storage online.

SQL> alter table table_name move partition partition_name tablespace low_tbls update indexes online;

SQL> alter table table_name move partition partition_name row store compress advanced update indexes online;