1

Need some help here.

I have an ETL process which loads the data into a target table A. We have created another table B which is same as the target table in structure and this table is accessed by reporting team to generate reports. This is done to minimize the downtime for report generation. This way the reports are always accessing the latest data.

Target table B is a List partition table, partitioned on Client ID. ETL team loads data for each client in the respective partition, in Table A.

I tried doing it with Exchange partition: exchange partition mechanism to swap the segments of A and partitioned table B. But couldn’t do it as both tables are List partitioned and Oracle doesn’t like that. I created partitions so as to avoid creating multiple tables (TableA_ClientId) for each Client.

My other option: whenever data is loaded into target table A, rename the table B as table Temp, table B as table A and table A as table Temp.

Can you please suggest a better approach.

  • 2
    I'm voting to migrate this to dba.stackexchange.com – Dave Costa Feb 16 '21 at 19:32
  • Sure @DaveCosta. Can you let me know how to do this? Would I need to delete this Q and add it on dba exchange? – Manish Mishra Mar 02 '21 at 14:42
  • If enough viewers vote to close & migrate, it would be moved to the other site automatically. I don't know if there's a way for you to migrate it yourself. Since there's been no answers posted, you might as well just create a new question on the other site. – Dave Costa Mar 02 '21 at 15:45
  • Sure @DaveCosta. I've created a new Q on dba exchange. We can close this Q now. – Manish Mishra Apr 07 '21 at 15:43

0 Answers0