expdp from Oracle 12 to Oracle 11 locks account after import
<p>I exported a schema from Oracle 12 to Oracle 11 with the <code>version=11.1</code> option using datapump's <code>expdp</code> command. After the import of the schema on the Oracle 11 database the accound was locked.</p>

<p>When I checked the ddl of the <code>impdp</code> statement, generated with the <code>sqlfile=dump.dll</code> option, I found this:</p>

<pre><code> CREATE USER "IAMUSER" IDENTIFIED BY VALUES '...'
      DEFAULT TABLESPACE "MY_TABLESPACE"
      TEMPORARY TABLESPACE "TEMP_TABLESPACE"
      PASSWORD EXPIRE
      ACCOUNT LOCK;
</code></pre>

<p>Does anyone know why this is happening? Obviously the password is set to <code>EXPIRE</code>, even though the default on the server is set to <code>UNLIMITED</code> and the account is locked, so one would have to unlock it manually after the import.</p>