title: Steps to restore one table from impdp in oracle 10g
body: <p>I need to import only one table from a full backup (expdp) to a newly create table on the same database.</p>
  
  <p>So can i import the table directly with a new name? or i have to create a new table first with the same parameters then import?</p>
  
  <pre><code>impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expschema.dmp TABLES=hr.employees REMAP_TABLE=hr.employees:emps 
  </code></pre>
  
  <p>Another question will remap_table effect my already exist employees table? or it will only create a new table called emps and import the data of employees from the dump to it? </p>
  
  <p>...................... Update ......................</p>
  
  <p>I found that there is no remap_table in oracle 10g so can i use this method:</p>
  
  <pre><code>create user johny identified by 1234;
  grant create session to johny;
  impdp  system/****** DIRECTORY=dpump_dir1   DUMPFILE=expschema.dmp  LOGFILE= tb_imp.log  TABLES='HR.employees'  REMAP_SCHEMA=HR: johny;
  </code></pre>
  
  <p>We need the table temporarily only so i can drop johny later. also the above method will not effect the original employees table in the hr schema , right?</p>