title: Avoiding error rows during Oracle dump import
body: <p>I am using Oracle's <code>imp/exp</code> utility to transfer database to another server.
  First I have created an empty database with the same tablespaces as the source database.</p>
  
  <p>When I use <code>full mode</code> the result of the import is fine the database is working correctly but I got huge number of errors because of existing system objects.
  It is fairly disturbing and I cannot check whether there are "real" error messages.
  An option would be to used <code>ignore=Y</code> but according to the <a href="http://docs.oracle.com/cd/B10500_01/server.920/a96652/ch02.htm#1014036" rel="nofollow">docs</a> it means the table data may be duplicated. This does not sound good. Or if I import only once there would be no duplication?</p>
  
  <p>I could also use <code>user mode</code> import but it seems to me according to <a href="http://docs.oracle.com/cd/B28359_01/server.111/b28319/exp_imp.htm#i1004890" rel="nofollow">this table</a> that important parts will not be imported this way and I think it should also be avoided.</p>
  
  <p>What could be the solution? </p>
  
  <p>Should I use <code>expdp/impdp</code> instead, do they solve this problem?</p>
  
  <p>Thanks in advance.</p>