SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automate exporting oracle table data to csv file in unix environment with shell scripting

ravi.y.kiranJul 10 2017 — edited Jul 10 2017

Hi All,

I need help on exporting data from a table to csv and transfer the file to a shared location using SFTP in Unix.

Step 1 . Login to Unix and connect to Oracle database. Select data of specific table (for eg: select empno, empname from employee).

Step 2 Export employee table data and generate a csv file.

Step 3 Move generated csv file in step 2 to AWS (Amazon web service) cloud using SFTP.

Step 4 Automate the whole thing with crontab or similar.

Note: Everything is in Unix environment.

Can anyone help me in how to achieve this?

Thanks

Ravi

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2017

Added on Jul 10 2017

7 comments

2,170 views