CODEWITHSUNDEEP
javaoracle-databaseexport-to-csvimport-from-csv
umang
umang

Reputation: 25

extract data in csv from table with 2 billion records

Wanted to know the tool which can extract data in csv from a table or by executing a sql query like

select * from table 1 inner join table 2 on ...

Data is currently in oracle database and required to be extracted in csv and processed through Java code and after processing final csv/multiple csv files required to be loaded back to same oracle database .

Is there any tool script does this task efficiently

Upvotes: 0

Views: 454

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59558

I think this is a very bad idea. Anyway, you can use the ODBC Driver "Microsoft Text Driver (*.txt; *.csv)" which should be available on each Windows.

Setup the connection in ODBC Administrator odbcad32.exe

enter image description here

enter image description here

And then you can select the data with any generic ODBC capable SQL tool, e.g. WinSQL or DBeaver

Upvotes: 0

Related Questions