Python - Download a 20 gb of dataset/datadump from Oracle server to my local disk drive using Python

downloadfile
data_mining
python

#1

Hi All,
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.

Thanks!!