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 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.