ron
Member
OE 11.6.3.017 on 64-bit Solaris
We have a 2 TB DB (actually 6 DBs that 'act' as one) - and we are in the process of migrating from 10.1C to 11.6.
I just read Tom Kincaid's blog about partitioning - in particular in an environment where very large tables are involved. He used an example of migrating chunks of about 3 months of data each time. My question is: does this mean ending-up with a multitude of partitions - each containing data for a 3-month period? Or can one simply move the partition (date in this case) boundary by 3-months to migrate another 3 months of data without creating a new partition?
Ron.
We have a 2 TB DB (actually 6 DBs that 'act' as one) - and we are in the process of migrating from 10.1C to 11.6.
I just read Tom Kincaid's blog about partitioning - in particular in an environment where very large tables are involved. He used an example of migrating chunks of about 3 months of data each time. My question is: does this mean ending-up with a multitude of partitions - each containing data for a 3-month period? Or can one simply move the partition (date in this case) boundary by 3-months to migrate another 3 months of data without creating a new partition?
Ron.