Install Oracle DB

1. Download Oracle DB 12c :
   1. https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.html
2. Connect to sqlplus :
   1. Open cmd and type : CONN / AS SYSDBA
      1. And  if CONN / AS SYSDBA is not working then type : Sqlplus / as sysdba
   2. 1)      Create dump directory

      CREATE DIRECTORY dump_dir as ‘E:/dmp’

       

      GRANT READ, WRITE ON DIRECTORY dump_dir TO system;

       

      And place your dmp file in E:/dmp folder

      Now exit the sqlplus and run the below command directly on shell

      2)      Import dump file

      impdp system/<password>@ORCL directory=dump_dir  dumpfile=DB12c1.dmp logfile=imp_tab.log full=Y

       

      here DB12c1.dmp is your dmpfile name