Hi All, I have a large table partioned by month. I would like to run a query - which adds derived data to the current data and inserts the data into a new table. The new table is the target for users.
How can I iterate over the partition tables to insert data and build the new table? This is done monthly, am I better off creating a materalized view each month? Best, Glenn
