title: IMPDP in Oracle 11g - From One Schema to other Schema
body: <p>I used to run commands to get Oracle database backup in the old way using 'exp' and 'imp fromuser touser. Now, I am trying to user new command to take backup 'expdp' and 'impdp'.</p>
  <h2>Steps:</h2>
  <ol>
  <li><p>Got backup using expdp with schema parameter on the production server. my username is 'xxx' (Not sure it's fully exported with procedures, function, and view).</p>
  </li>
  <li><p>Now, on my dev server first I made another user called 'yyy'. I gave directory access to user 'yyy' and trying to run command impdp as below.</p>
  <p>C:\impdp yyy/yyy remap_schema=xxx:yyy directory=abc dumpfile=123.dmp logfile=123.log</p>
  </li>
  </ol>
  <p>Now, I am getting an error like the below.</p>
  <pre><code>Import: Release 11.1.0.6.0 - Production on Thursday, 24 January, 2013 9:53:58
  
  Copyright (c) 2003, 2007, Oracle.  All rights reserved.
  
  Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
  
  With the Partitioning, OLAP, Data Mining, and Real Application Testing options
  ORA-31626: job does not exist
  ORA-31633: unable to create master table &quot;yyy.SYS_IMPORT_FULL_05&quot;
  ORA-06512: at &quot;SYS.DBMS_SYS_ERROR&quot;, line 95
  ORA-06512: at &quot;SYS.KUPV$FT&quot;, line 978
  ORA-01031: insufficient privileges
  </code></pre>
  <p>Do I miss any steps? like I have to create a job or anything, not sure. basically, I got backup from one user and need to restore on another user in Oracle.</p>
  <p>Please help me.</p>