title: How Can I import or open a .dmp file?
body: <p>Update:</p>
  <p><a href="https://i.stack.imgur.com/O6DoQ.png" rel="nofollow noreferrer">I tried the impdp command and it's giving me that it cannot create a user. I tried creating the user as well</a></p>
  <p><a href="https://i.stack.imgur.com/Kdbem.png" rel="nofollow noreferrer">This is how my .par file looks like</a></p>
  <p><a href="https://i.stack.imgur.com/w0GbE.png" rel="nofollow noreferrer">This is a snip of .sh file</a></p>
  <p><img src="https://i.stack.imgur.com/K6iba.png" alt="enter image description here" /></p>
  <p>I have never used the oracle database before. I have a .dmp file which is 50 GB. I don't know how it was exported or which version it was exported from. I downloaded Oracle 12c release 2 and tried to do an import but I get the error &quot;.dmp may be a Data Pump export dump file&quot;. What do I need to do so that I can run SQL queries on it eventually? Please see the attached image.</p>
  <p>UPDATE :
  I tried the command :
  IMP SYSTEM/Password SHOW=Y FILE=DBO_V7WRIGLEY_PROD_20180201_TECHOPS-5527.dmp fromuser=SYSTEM touser=SYSTEM</p>
  <p>It gave me a message saying import terminated successfully with warnings. what does this do? Also, where can I view the data now if it's imported?</p>