Let’s create Interval-Partitioned table and exchange partitions. Step 1 : Create Interval Partitioned Table Let’s insert some records in TRAN_ALL table. I have staging table which has some records . Let’s create one table using structure of above table with which we can exchange partition of TRAN_ALL table. Let’s exchange partition : Thank you for […]
Articles Tagged: exchange partition
Exchange Partition in Oracle
Exchanging Partitions is something new. And it provides a huge benefits. By exchanging partition you can actually get data quickly in or out of partitioned table. The data that resides in the partition is exchanged with given non partitioned or partitioned table without deletion and insertion operation. Things to be taken care of while performing […]