Hi Experts,
We have a table which keeps data for around 200 companies and the table has 18 billion records now( this is weekly partitioned), and it maintains data for 18 months. Now the retention policy has been updated and we have to maintain data for last 7 years.
Considering the data size, we rearchitected and decided we will go for a table for a company and will create 200 Tables in stead of one table, and we are planning to create CTAS table for each company.
So I need expert advice here, what would be the best approach to move the data to individual tables.
We are also using Active data guard and current version of the oracle DB is 19c.
Please help me any other out of box approach or thoughts.
Thanks in advance !!!