Appreciate the reply,
I couldnt do this at the database level because each file comes from a different database. One is from oracle and other is from netezza. Is there any way to do that...
techquest
Last Activity: Jun 24 '08, 06:21 PM
Joined: Jun 23 '08
Location:
-
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....Leave a comment:
-
Need to connect oracle database using Unix script
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... -
Need a unix script to do match two files
Hi,
My req is to compare two files data. Basically these files would have been a exported data from Oracle database. It will follow the table structure. Using this structure, i want to compare the column level data between these two files.
For ex;
Data of File 1
10,test1,column 3
20,test2,column 3
Data of File 2
10,test1,column 3
40,test2,column 3
...
No activity results to display
Leave a comment: