title: Can I, and how to, query severals database schemas with IntelliJ database tool?
body: <p>I'm using IntelliJ to create my application, and an Oracle Database.</p>
  
  <p>At the moment, I have to migrate data from an older database <code>SCHEMA</code> to a newer one. Tables and columns changed, and I want to create a IQBase script, which will be run on the different server during installation of the new application version.</p>
  
  <p>So I have got, data in the old <code>SCHEMA</code> (we will talk about <code>OLD_SCHEMA</code>) and I want to <code>SELECT</code> these data, transform them and <code>INSERT INTO</code> the <code>NEW_SCHEMA</code>. So I wanna do something like :</p>
  
  <pre><code>INSERT INTO NEW_SCHEMA.TABLE_X (........) SET (SELECT ..... FROM OLD_SCHEMA.TABLE_Y)
  </code></pre>
  
  <p>BUT When I'm trying to executing this kind of query in the database tool bundled with IntelliJ, I got an error explaining, that there is a non existing table or a view.</p>
  
  <pre><code>[2016-09-06 15:22:29] [42000][942] ORA-00942: Table ou vue inexistante
  </code></pre>
  
  <p>It seems normal, because, when I create a SQL console file to test my queries, it is linked to one of the two schema.</p>
  
  <p>So, can I , and if I can, How to execute my queries to use data of the two schema ?</p>
  
  <p>Thank you.</p>
  
  <p>PS : An Import, export isn't the solution, the structure changed a lot.</p>