471,354 Members | 2,104 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Need to connect oracle database using Unix script


I want to connect into oracle database and export the table data into a flat file using UNIX shell scripts. I cant use other GUI tools to do this, as the dataload will be in millions. hence if i try to export from toad/sqlplus its hanging. And also i need to some validation using UNIX. So please give me some tip to write a script which does this operation.

1) Connect oracle
2) Select * from employee
3) Write into some flat file in a proper format using some delimiter.
4) Need to match this flat file with another file which will also be in the similar format.

Thank you.
Jun 23 '08 #1
3 6284
8,127 Expert 4TB
try to use QUERY REPORTER.
Jun 24 '08 #2
try to use QUERY REPORTER.
Thanks for the reply,

Oracle database is installed on Unix and i want to export it into a flat file to perform some data validation. So in what way this query reporter would help me. Can you pls explain me about that tool like how i can use it for this req.
Jun 24 '08 #3
8,127 Expert 4TB
QUERY REPORTER is a window based tool to extrat data to flat file. it does not matter where the database resides or in which environment. After all this is a free tool.
Jun 25 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Azhar Bilgrami | last post: by
5 posts views Thread by Kona | last post: by
1 post views Thread by Yanick Quirion | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.