The unique thing about partitions is that you can modify the data in one partition without touching the other partitions, and without slowing the response time of queries using those other partitions.
Oracle provides a new feature, called exchanging partitions, that allows you to build all the data you need for a partition ahead of time.
First, you create a table and load the data into the table. Then, you issue the appropriate command, and the data in the current partition is traded with the data in the
table. This occurs without actually moving any data, changes to the internal mapping that Oracle uses to track where the partition's data is located cause the exchange.
One example of using this technique occurs when you refresh a large data warehouse with current data. First, you move the table to the data warehouse using the
transportable tablespace feature. Then, you can use the exchange partition feature to move the data into your partitioned table.
The larger the amount of data involved, the more economical this new feature becomes.
Look at the following MouseOver to see the syntax for this new feature.