Expdp and Impdp table of a schema in Oracle

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;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply