Обсуждение: Delete from base table and not partitions

Поиск
Список
Период
Сортировка

Delete from base table and not partitions

От
Nuwan Liyanage
Дата:
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.