hi All,
We are in the process of migrating our existing Oracle 11g database to 12c. The database size is around 170 TB and we want to migrate only 6 TB of data that is around
3 months’ worth of the data. There are around 200 partitioned tables range partitioned by day in this database. So we are thinking of 2 approaches to achieve the migration-
1. Traditional datapump export/import approach : In this case we will identify all the partitions of 3 months in 200 tables and perform export/import in bunches to target
database. We will not be able to do this in single weekends so it would be span multiple weekends. In this case, we will target all the historical partitions first and
on the day of go-live, we will target perhaps 2 weeks data which is around 1 TB.
2. Transportable tablespace approach: In this case, we will move 3 months data partitions to a new tablespace which will be a part of our transportable tablespace set.
This seems to be valid approach considering we have large amount of data to migrate that we can do in a single weekend. But to be able to use TTS we should have self-contained tablespace (TBS).
So in this case we cannot keep partitions of a table in 2 tablespaces and only transport the intended partitions. To overcome this we can do partition exchange all the intendent partitions to be individual tables and transport these tables to the target database and do a partition exchange in the target tables to attach these tables to main partitioned tables. But this will also require more works. Any other ideas for this.
Regards;
GK