title: Import dump file to another Database with default schemas
body: <p>I have the following command to import a dump file to another Database (DB_B) with different schema. Oracle's Data Pump import</p>
  
  <pre><code>impdp SYSTEM/PASSWORD DUMPFILE=dpump_dir1:expfull.dmp FULL=y LOGFILE=dpump_dir2:full_imp.log
  </code></pre>
  
  <p>expfull.dmp from DB_A contains alot of different roles, users, tablespaces and others while the DB_B is just a basic DB where I wanted to import my expfull.dmp it only contains default users, roles etc during DB creation. The usual steps I do to get an exact match of DB_A is to create each of these users and tablesspaces everytime I import a DB. Is there a command/flag where it will just automatically import all the contents of expfull.dmp to to DB_B without going through all the usual steps i just describe? I checked in google and oracle site there is remap_schema will somehow do this. But am not sure how it works or it does what i want. Any advice/help is greatly appreciated thanks in advance.</p>