title: how to import a dmp file with profiles from a CDB db to a PDB DB instance using impdp in Oracle 12c?
body: <p>I have a dmp file from a CDB(don't know exactly) in another server from where, I was given a dmp file which was exported using expdp(possibly). I want to import it into a PDB instance on an Oracle 12c server which I have.</p>
  <p>I extracted the sql file for the dmp file and there is profile by the name of 'C##APPPROF'. This dmp is of 2 schemas and the import fails where it tries to run 'CREATE USER' because the profile name doesn't exist.</p>
  <p>According to Oracle 12c docs, I cannot create a profile for a PDB instance in Oracle 12c starting with 'C##' since that is the convention for creating profiles in a CDB instance.</p>
  <blockquote>
  <p>In a non-CDB, a profile name cannot begin with C## or c##.</p>
  </blockquote>
  <p>This is the command which is currently used.</p>
  <blockquote>
  <p>impdp &quot;sys/Oradoc_db1@ORCLPDB1 as sysdba&quot; directory=MY_DATA_PUMP_DIRECTORY dumpfile=corp.dmp logfile=MY_DATA_PUMP_DIRECTORY:logfile.log exclude=GRANT</p>
  </blockquote>
  <p>Is there a way, I can overcome this ?</p>