Split Partition in Oracle

Oracle split partition feature allows you to split partition which are already created. We can take benefit of this feature when in specific partition lots of records are inserted and its tough to maintain it individually. In this post we will see how can we partition different types of partition. 1.Splitting a partition of range-partitioned […]

Read More

Export and Import of Partition

In this post we will see export and import operation of a table partition. Let’s see step by step. Step 1 : Create a directory¬† Step 2 : Run expdp command to take partition backup We can see in above output I have defined tables=TRANSACTIONS_MAIN:Y_2015 clause which will export Y_2015 partition of TRANSACTIONS_MAIN table. We […]

Read More

Load a Partition with SQL*Loader

In this post we will see how we can insert records in specific partition using sql*loader. Step 1 : Create a .dat file which contains records Step 2 : Create .ctl file In above output we can see I am trying to insert records in L1 partition of TEST_LOADER table. Step 3 : Prepare a […]

Read More