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 can see here total 2222 records exported for Y_2015 partition.

Now in next step I will truncate this partition and import the partition using above taken backup.

Step 3 : Truncate Partition 

Step 4 : Import partition

We can see here partition is successfully imported.

Step 5 : Let’s check in table that partition is successfully imported and rows are inserted.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.