Excluding tables while performing datapump import from Full schema backup

Share via:

Hello Everyone,

In this article , we will learn Excluding tables while performing datapump import from full schema backup.

Database : AVPROD

Schema : OT

Check objects count  in OT Schema.

Take full schema backup using schema=OT

Full schema backup completed , now we can transfer dumpfile to  target server using SCP.

Connect to Target server, and start import datapump by excluding few tables.

To exclude few tables while import operation we can use a parameter called EXCLUDE.



CONTACTS,COUNTRIES and CUSTOMERS tables are excluded successfully from the full schema backup.

Validate table count in Target server 


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

Follow us on 
Website  www.ktexperts.com
Facebook Page KTexperts
Linkedin Page : KT EXPERTS


Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Add Comment