title: Using Oracle "Create User" command does not automatically create an associated schema
body: <p>I'm just getting started with Oracle data export and import and things worked perfectly fine the first time around. But then I came back next day repeated the exact same steps on the same systems, but get ORA-01435: user does not exist error.</p>
  
  <p><strong>System Specs for all machines:</strong></p>
  
  <p>-OS: Windows 2012 R2 x64</p>
  
  <p>-Oracle Server: Oracle 11G Express x64</p>
  
  <p><strong>Objective:</strong>
  I'm exporting data from Oracle server 1 and importing to Oracle server 2.</p>
  
  <p><strong>Procedure:</strong>
  Export data dump is successful from Oracle server 1.</p>
  
  <p>but when importing the data dump on Oracle server 2, I follow this procedure:</p>
  
  <p>-Stop IIS service</p>
  
  <p><code>net stop WAS</code></p>
  
  <p>Create Schema/user account and Grant privileges before import</p>
  
  <pre><code>net stop WAS
  
  sqlplus / as sysdba;
  
  CREATE user PIE1 identified by PASS1;
  
  GRANT ALL PRIVILEGES TO PIE1;
  
  GRANT IMP_FULL_DATABASE TO PIE1;
  </code></pre>
  
  <p>According to oracle, all goes well, but look at the first image bellow. In DBeaver, I can see that only the User account PIE1 has been created, but NO schema.
  <a href="https://i.stack.imgur.com/PFmE2.png" rel="nofollow noreferrer">Oracle issue 1. User account created, but not the Schema</a></p>
  
  <p><strong>Question 1:</strong> According to Oracle, the command "Create User" IS supposed to also create an associated Schema. Anyone have an idea why this is no longer working for me? It worked once the night before.</p>
  
  <p>I then continue the import procedure as follows:</p>
  
  <pre><code>imp PIE1/PASS1@xe file=c:\Backups\AVUSER2_6_7.dmp log=c:\Backups\import.log fromuser=AVUSER2_6_7 touser=PIE1;
  </code></pre>
  
  <p>But get the following error:
  <a href="https://i.stack.imgur.com/8yqw0.png" rel="nofollow noreferrer">Oracle claims the User doesn't exist even though it does</a></p>
  
  <p>Oracle claims the User doesn't exist even though it does. I repeated the entire procedure and even created an identical import/export user account and credentials, and this error still comes up.</p>
  
  <p><strong>Question 2:</strong> Any idea why Oracle "Can't find" a user account that's clearly in the database?</p>
  
  <p>Additional Info:</p>
  
  <ol>
  <li><p>Checked that my windows account is in admin group</p></li>
  <li><p>Checked that my windows account is in ORA_DBA group</p></li>
  <li><p>Opened all CMD prompt as Admin</p></li>
  </ol>