We are on RHEL 8, Oracle DB 12+ and Python 3.9
I am trying to find the fastest way to extract large data from Oracle DB to local Linux file system in form of flat file (csv, txt, etc)
Data we extract from some Oracle tables could be in GBs with 2-3 billion records.
I am planning to use oracle_cx or it’s replacement oracledb module and 4 threads.
I would greatly appreciate any recommendations from more experienced members who might have done this. Any options using Python would work and we can try those out.
Thank you in advance.