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