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