Hi Experts,
I have two tables Tab1 and Tab2. Both are having around 10Billion records, and both the tables are partitioned on a date called entry_Date week wise.
Each table has 20 Columns.
Currently I am moving each partition wise from Tab1 to Tab2 and each partition is taking around 10Minutes for 10 Million records for a week.
Is there a better approach for this can Create a third table
Create table3 as select from Tab1 union all Select * form Tab2, once done can I rename the table3.
Please share me some good approach.
I am using Oracle 19c Exadata.