Tag Archives: Expdp single table

How to Backup Tables in Oracle with EXPDP and IMPDP

EXPDP or IMPDP backup for tables in Oracle

Create a directory in Oracle:

Create directory DBBACKUPDIR as 'C:\dbbackup';
GRANT READ, WRITE ON DIRECTORY DBBACKUPDIR TO SCOTT;

Expdp backup for the table in Oracle:

--For one table
expdp system@xepdb1 tables=HR.EMPLOYEES directory=DBBACKUP dumpfile=HR.dmp logfile=EXPDPHR.log

-- For two tables
expdp system@xepdb1 tables=HR.EMPLOYEES,HR.JOBS directory=DBBACKUP dumpfile=HR.dmp logfile=EXPDPHR.log

Impdp backup for the table in Oracle:

impdp system@xepdb1 directory=DBBACKUP dumpfile=HR.dmp logfile=IMPHR.log