title: How to spool data into a flat file from a different schema/database by using sql loader?
body: <pre><code>SELECT column1
  FROM (SELECT column1 FROM SCHEMA_B.ABC);
  </code></pre>
  
  <p>The above is a sample of my spool script attempting to spool data into a flat file from a different database.
  What are the steps to make it happen? Do I need permission/access to that database? How does it work? I am fairly new to this, so a thorough explanation will be appreciated.</p>
  
  <p>Thanks in advance.</p>