Oracle database table field C as A list partition, and want to watch A field D as partition, how to handle,,
Table A volume of data is very large, , have A great god solve,

CodePudding user response:

Or a LIST of partitions can be converted into range partitions

CodePudding user response:

If there are window period of downtime, can delete table reconstruction,

CodePudding user response:

Thank you for your answer, but also want to overweight before new build partition table, and then make a copy of the original table data, but the source table data volume is larger, must level, use the create table select * from the source table, more consumption of resources, and the time is long, worry that affect other business operations, as well as the normal batch

CodePudding user response:

I'm afraid partition strategy is adjusted can only be rebuilt

CodePudding user response:

No more than two ways:
1. Application outage window, low risk of ctas parallel reconstruction,
2. Online redefinition non-stop, risk is big

CodePudding user response:

If is oracle18c later version, you can direct online changed,
Example:

 ALTER TABLE jyc_test1 MODIFY 
Partition by list (d) 
(p1 partition values (1,2,3,4,5,6,7,8,9,10), 
,12,13,14,15,16,17,18,19,20 partition p2 values (11), 
Partition p3 values (default) 
); 

CodePudding user response:

Build a to D field partition of a partitioned table (how to define your own), then use exhcange partition the source partition table data migration in the past, the fast, and relatively safe

CodePudding user response:

Seems the only way is to build table, the safest way, or for downtime,
Built table is finished, can use window, open multiple processes, don't write the log import data quickly,