my DB is oracle 11.
develop language is python 2.7.
i use following statement to get record from DB. and the row number is nearly 0.5 billion
statements:
sql = "select count(*) from dwrsdm.bl_inv_stock_erp "
cursor.execute(sql)
result = cursor.fetchall()
print result;
sql = "select * from dwrsdm.bl_inv_stock_erp"
cursor.execute(sql)
result = cursor.fetchall() -------error happen
error happen when it run the second " cursor.fetchall()", it prompt
"cx_Oracle.OperationalError: ORA-03113: "
I am sure the error happen for the return records is too huge. How can I solve the problem?