Oracle Data Pump Selective Backup INCLUDE & EXCLUDE Step by Step

In this video, you will learn how to use INCLUDE and EXCLUDE options in Oracle Data Pump (EXPDP) to take selective backups. This tutorial covers correct command syntax to avoid common errors like ORA-39071, ORA-00904, and shell quoting issues. 🔹 Topics Covered: ✔ What is INCLUDE and EXCLUDE in EXPDP ✔ Export full schema vs selective objects ✔ Exclude single table ✔ Exclude multiple tables ✔ Include specific objects ✔ Common errors and fixes ✔ Best practices using command line 🔹 Commands Used: Note: You can remove the forward (\) slash if commands is not running on your system 1️⃣ Full Schema Export: expdp hr@pdb2 directory=dbbackup dumpfile=full_hr.dmp schemas=hr logfile=full.log 2️⃣ Exclude Single Table: expdp hr@pdb2 \ directory=dbbackup \ dumpfile=exclude_emp.dmp \ schemas=hr \ logfile=exclude_emp.log \ exclude=TABLE:\"=\'EMPLOYEES\'\" 3️⃣ Exclude Multiple Tables (Recommended): expdp hr@pdb2 \ directory=dbbackup \ dumpfile=exclude_multi.dmp \ schemas=hr \ logfile=exclude_multi.log \ exclude=TABLE:\"IN \(\'EMPLOYEES\',\'DEPARTMENTS\'\)\" 4️⃣ Exclude Using LIKE: expdp hr@pdb2 directory=dbbackup dumpfile=exclude_like.dmp schemas=hr logfile=exclude_like.log exclude=TABLE:\"LIKE \'EMP%\'\" 5️⃣ Include Only Tables: expdp hr@pdb2 directory=dbbackup dumpfile=only_tables.dmp schemas=hr logfile=only_tables.log include=TABLE 6️⃣ Include Specific Table: expdp hr@pdb2 directory=dbbackup dumpfile=only_emp.dmp schemas=hr logfile=only_emp.log include=TABLE:\"=\'EMPLOYEES\'\" 7️⃣ Exclude Indexes: expdp hr@pdb2 directory=dbbackup dumpfile=no_index.dmp schemas=hr logfile=no_index.log exclude=INDEX 🔹 Important Points: * Do not use INCLUDE and EXCLUDE together * Always use correct quoting syntax * Use multiple EXCLUDE parameters for better reliability * Command line quoting is handled by shell before Oracle 🔹 Who should watch? * Oracle DBAs * Beginners learning Data Pump * Interview preparation 👍 If you found this helpful, like, share, and subscribe for more Oracle DBA tutorials! #Oracle #EXPDP #DataPump #OracleDBA #SQL #DatabaseBackup #IncludeExclude