Expdp of table in Oracle database
Create a directory in Oracle
Create directory dbpump as 'E\backup'
Grant the permission on the directory for backup
Grant read,write on directory dbpump to scott;
Take backup of the table scott.employee table
expdp scott/tiger TABLES=schema_name.table_name1 DIRECTORY=dbpump
DUMPFILE=tables_backup.dmp LOGFILE=tables_backup.log
Impdp of table in Oracle database
impdp scott/tiger TABLES=schema.table_name1 DIRECTORY=dbpump
DUMPFILE=tables_backup.dmp LOGFILE=tables_backup.log;