[dfads params=’groups=-1′]
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
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY my_data_app
LOCATION (‘bulk_kyc_xt.dmp’)
)
AS SELECT * FROM bulk_kyc_upload_by_employer_af;
select * from bulk_kyc_xt;
drop table bulk_kyc_xt;
[/code]
In order to import oracle table from a csv file using oracle external table, click here.
[dfads params=’groups=-1′]