Question: I have a base table with several temporal partitions like this:
base_table
partition_1
partition_2
There are check rules on partitions, and trigger rules on the base
table to ensure data loaded into base_table goes to a correct
partition.
I added partition_3 and created the check rules on it, but forgot to
add trigger rules on the base_table. So for a while data inserted into
base_table and meant for partition_3 was actually inserted into
base_table.
Now I added the trigger rule to base_table and the data for
partition_3 is going to the right place, but I am stuck with some data
in the actual base_table. How could I move that data from the base
table to the partition_3?
thanks.
Never miss a thing.
Make Yahoo your homepage.