title: Bulk inserts into Oracle database via Python's jaydebeapi
body: <p>I want to bulk-copy data from SQLite3 files to an Oracle DB, and do so programmatically from within a Python script using the <code>jaydebeapi</code> module.  (I have no control over the choice of Python + jaydebeapi to do this; it is imposed by the project I am collaborating in.)</p>
  
  <p>One way to do it would be to dump the SQLite3 tables to temporary CSV files, and use Oracle's <code>LOAD DATA INFILE</code> command to read the CSV files.</p>
  
  <p>I am looking for a way to achieve the same end result that avoids creating the intermediate temporary files.</p>
  
  <p>More specifically, since I can bulk-read the SQLite3 tables into memory (with simple <code>SELECT</code> statements), what I need is the bulk-write counterpart to dump the tables from memory into the Oracle database.</p>
  
  <hr>
  
  <p><strong>EDIT:</strong> This is a recurrent task.  The largest table to be copied has typically ~100K rows.</p>