Automate several table download in csv format from Oracle database

heman Aug 3, 2013 4:24 AM

Hi All, I am new to Oracle database usage and currently using SQL Developer and PL/SQL for my day to day work. Please help me with the below.

Currently I am querying a table for few columns and using EXPORT facility from Query Result tab. However, I want to do this for several tables. If possible I would like to keep all these table downloads as overnight job. Is there a way to do this?

Thanks in advance.

1. Re: Automate several table download in csv format from Oracle database

heman Aug 3, 2013 4:28 AM (in response to heman)

Also, please be informed that I have SQL*plus, access through UNIX as well. Suggestions are most welcome.

Thanks.
Like Show 0 Likes(0)

Actions
2. Re: Automate several table download in csv format from Oracle database

heman Aug 6, 2013 2:34 AM (in response to heman)

Hi Team, can anyone advise if I have posted this query in inappropriate forum. Normally I have seen other posts are answered reasonably at a faster pace. Please help me.

Thanks, heman
Like Show 0 Likes(0)

Actions
3. Re: Automate several table download in csv format from Oracle database

Christian Erlinger Aug 6, 2013 6:46 AM (in response to heman)

I guess you should post this in the SQL Developer forums. However; if you don't mind using other tools I have an idea: recently a feature has been added to the free mod_owa module to output a ref cursor in various formats; e.g. in CSV:

https://oss.oracle.com/projects/mod_owa/dist/documentation/modowa.htm#_refcur

so in essence you'd need a stored procedure returning ref cursors and an apache with the module configured. You'd simply have to do HTTP Requests and store the response in a file.

cheers
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.