title: Read and write Clob data using python and cx_oracle
body: <p>Am trying to read Clob data from test db and inserting it in dev db. Am able to do that but the performance is very poor.
  For 100K rows its taking 8 to 12 hours, and running it from my local machine.
  Am wondering if my approach is correct or is there any better way in doing it.
  Below is my code after connections:</p>
  
  <pre><code>for row in rows.fetchall()
     x = []
     data = row.read
     json_data = json.loads(data)
     x.append(json_data)
  </code></pre>
  
  <p>This is how am doing it. Just wanted to know if there is any better way to do it.
  Stack : Python, OracleDB, cx_oracle, json
  Thanks</p>