I am using the cx_Oracle executemany() function to insert 500,000 rows into a table in batches of 200,000. The function works on RHEL Linux and fails on Windows 7. The issue persists regardless of user, database, and table. The issue only occurs when inserting more than ~150,000 rows. Please help me understand why this fails on Windows and how to solve the issue.
Error message is ORA-03114: not connected to ORACLE.
# Create an Oracle connection
connection = cx_Oracle.connect(user= user, password= pwd, dsn = tns)
# Create a cursor
cursor = cx_Oracle.Cursor(connection)
# Compile the insert SQL w/ bind variable
# Execute the insert statement, commit & close connection
# In case of error, still close the connection!
# This avoids a table lock when accessing the table from a different connection
# at a later date, if this Python session is still active
except Exception as e: