There are various ways to export oracle database tables. Here, I was dealing with large database tables when I was working at one of the india’s biggest government company. I had to import and export crores of tuples from and to csv files.
Following is the simplest example to unload data from huge oracle database to a dump file using oracle_datapump driver in Oracle External Table.
[code]create or replace directory my_data_app as ‘D:my_data_app’;
create table bulk_kyc_xt
DEFAULT DIRECTORY my_data_app
AS SELECT * FROM bulk_kyc_upload_by_employer_af;
select * from bulk_kyc_xt;
drop table bulk_kyc_xt;
In order to import oracle table from a csv file using oracle external table, click here.