Oracle Import and Export DMP file

1. Create Oracle directory, login with user Sqlplus

   Create or replace directory dpdata1 as '/a/b ';

2. Grant permission, dba Login Sqlplus

   Grant Read,write on directory dpdata1 to user;
   

3. Exporting DMP

   A. Export by table, under Bin directory
   

   ./EXPDP User/[email Protected] tables=table1,table2 dumpfile=expdp.dmp directory=dpdata1;

   B. Export by user

   ./EXPDP User/[email Protected] schemas=user dumpfile=expdp.dmp directory=dpdata1;
   

4. Importing DMP

   A. Import the Dmp,bin directory exported by table

   ./IMPDP User/[email Protected] directory=dpdata1 dumpfile=expdp.dmp full=y logfile=impdlog.log;

   B. Importing DMP that is exported per user

./IMPDP User/[email Protected] directory=dpdata1 dumpfile=expdp.dmp schemas=user logfile=impdlog.log;

Oracle Import and Export DMP file