migration

ORACLE 12C: Data Migration Assistant

The Database Migration Assistant for Unicode (DMU) provides a good solution for migrating databases from legacy character sets to the Unicode character set. It is shipping with Oracle Database 12c Rel.1 and becomes the officially supported method for migration to the Unicode character set. Database Character Set Scanner (CSSCAN) and CSALTER utilities are removed from the database installation and have been desupported. DMU also supports migrating selected prior database releases of 10.2, 11.1 and 11.2. Oracle DMU 2.1, released in May 2015, supports a near-zero downtime migration model in conjunction with the Oracle GoldenGate replication technology. Using DMU2.1 and GoldenGate Read More

Migration of a table partitioning

Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c. When an “online” clause is specified, all dml operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. No dml operations are allowed if the partition|sub-partition is moved offline. some examples … SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name; Move a table partition|sub-partition to a new tablespace offline. SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name UPDATE INDEXES ONLINE; Move a table partition or sub-partitioning online maintaining any local/global Read More