Need to connect oracle database using Unix script

[techquest]

Hi,

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.

Req:
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.

[debasisdas]

try to use QUERY REPORTER.

[techquest]

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.

[debasisdas]

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.