want help for the following task :
I want to download a 20gb of dataset/datadump from Oracle server (oracle 11g database) to my local disk drive (i.e. E:/python/). I want to achieve this using Python 3.4 (windows64 bit ; I’m using Anaconda - spyder IDE)
I normaly use SAS for the task using following query:
LIBNAME ORACLE ODBC DSN= oracle UID= user PWD= password; #CONNECTION TO SERVER LIBNAME LOCAL "E:/PYTHON"; #SETTING LOACAL PATH FOR DATA STORE CREATE TABLE LOCAL.MYnewTable AS SELECT * FROM ORACLE.DOWLOAD_TABLE ;QUIT;
Above query will download 20GB of datadump from the server to my local E:/ drive using SAS. How to do the same in Python?? My RAM is only 4gb so downloading entire 20gb dataset in the Pandas’ data frame will eat up the RAM (i believe!! I may be wrong). SAS does this task very easily. Please suggest the query for Python. Request you all to share the code.