In previous post we saw modifying non-partitioned table into partitioned one.Today we will see how we can convert partitioned table into non-partitioned table.

To read non-partitioned table to partitioned table:

Step 1 : Lets check first table is partitioned one.

Step 2 : To convert partitioned table to non-partitioned one we need to take backup and import it using PARTITIONS_OPTIONS parameter option of impdp.

Let’s take backup first.

Step 3 : Let’s import the backup using PARTITIONS_OPTIONS parameter.

Here we need to specify merge value in PARTITIONS_OPTIONS that will merge all partitions and import as a single table.

Step 4 : Let’s check now table is imported as partitioned or non-partitioned table.

So you need to follow above steps to convert partitioned table to non partitioned table.

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:

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.