title: Seperating a Oracle Query with 1.8 million rows into 40,000 row blocks
body: <p>I have a project where I am taking Documents from one system and importing them into another.</p>
  <p>The first system has the documents and associated keywords stored. I have a query that will return the results which will then be used as the index file to import them into the new system. There are about 1.8 million documents involved so this means 1.8 million rows (One per document).</p>
  <p>I need to divide the returned results into blocks of 40,000 to make importing them in batches of 40,000 at a time, rather than one long import.</p>
  <p>I have the query to return the results I need. Just need to know how to take that and break it up for easier import. My apologies if I have included to little information. This is my first time here asking for help.</p>