title: Insert table data into another table in another schema in oracle
body: <p>i have 2 DBs</p>
  <p>the first one</p>
  <pre><code>username: name1
  password: password1
  hostname: pdprf.local
  port: 8080
  SID: prf
  </code></pre>
  <p>the second one</p>
  <pre><code>username: username2
  password: password2
  hostname: pdora.local
  port: 8080
  SID: prd
  </code></pre>
  <p>i am selecting data from a table in scehama 1 and i want to insert that data into table in scehma 2 - usually i export the data and insert it but i am looking for 1 line statment to do this - any ideas how to do that in oracle DB ?</p>