Hi Guys, I'm curious to know about any experience simulating updates/deletes to rows using partition exchange strategy.
Small lookup tables could be rebuilt by creating staging tables, but since select queries might be running how do we swap out the new table with the old one without select queries failing. Any simple way to do this, if anyone has implemented this workaround please share insights. Regards, Muji
