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