title: Import dump file
body: <p>I am totally new in oracle world and need help.
  I installed oracle free version OracleXE112_Win64 and has got a dump file that I need to import. 
  Is there anyone who can guide me how to do it?
  Thank's</p>
  
  <hr>
  
  <p>Can someone tell me what happens here when I import the dump file. I get the following:</p>
  
  <pre><code>Username: system 
  Password: 
  Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production Import data only (yes/no): no &gt; yes
  Import file: EXPDAT.DMP &gt; C:\Buildings22.dmp 
  Enter insert buffer size (minimum is 8192) 30720&gt; 30720 
  Export file created by EXPORT:V11.01.00 via conventional path
  Warning: the objects were exported by Buildings22, not by you
  import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
  import server uses AL32UTF8 character set (possible charset conversion)
  List contents of import file only (yes/no): no &gt; yes
  IMP-00402: Invalid parameter "SHOW" with data_only mode 
  IMP-00000: Import terminated unsuccessfully
  </code></pre>
  
  <p>How can I check if I import a dump file? 
  How can I display the content of dump file, tables in Oracle SQL Developer?
  I apologize for the issues, but I really brand new in oracle?</p>