Techniques for efficient dataloads into partitioned tables using swap tables

摘要

Techniques for efficiently loading data into a partition of a partitioned table of a database are provided. Data is stored in a swap table and the high water mark of the swap table has been reset prior to storing the data. The swap table is swapped with the partition. After the swap, the swap table becomes the partition of the partitioned table and the partition of the partitioned table becomes the swap table, and the swap table is truncated to reset the high water mark of the swap table.