Expdp backup for a single table in Oracle

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

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.