Database Backup & Restore Using Data Pump

 1. First we need to create Database Directory.

   CREATE DIRECTORY DB_BACKUP  AS 'D:\DATABASEB_BACKUP';
   GRANT READ, WRITE ON DIRECTORY DB_BACKUP TO HPP(Schema Name);

2. Provide Export/Import Privilege to Schema User:

   GRANT DATAPUMP_EXP_FULL_DATABASE TO HPP;
   GRANT DATAPUMP_IMP_FULL_DATABASE TO HPP;

3.Database Export Command For Specific Schema:

 EXPDP   HPP/HPP@ORCL schemas=HPP  DIRECTORY=DATABASE_BACKUP                    DUMPFILE=MRHS.dmp LOGFILE=full_exp.log   FULL=NO;

4.Database Import Command For Specific Schema :

    If user Exist Than First Drop User: DROP USER MRHS CASCADE;

   impdp  system/sys@ORCL  DIRECTORY = DATABASE_BACKUP  DUMPFILE = MRHS1.dmp             remap_schema=HPP:MRHS LOGFILE=full_IMPDp.log

5.Database Export Command For Multiple Schema:

 EXPDP   HPP/HPP@ORCL schemas=HPP,HPP_TRAN  DIRECTORY=DATABASE_BACKUP                    DUMPFILE=MRHS.dmp LOGFILE=full_exp.log  ;

6.Database Import Command For Multiple Schema :

    If user Exist Than First Drop User: DROP USER MRHS CASCADE;

    impdp  system/sys@ORCL  DIRECTORY = DB_BACKUP  DUMPFILE = hrms_07032022_v1.dmp             remap_schema=hrms:hrms,hrms_tran:hrms_tran LOGFILE=full_IMPDp.log