Home » Infrastructure » Unix » Comparing contents of a file with data in database
icon9.gif  Comparing contents of a file with data in database [message #208746] Tue, 12 December 2006 01:35 Go to next message
GautamSharma
Messages: 1
Registered: December 2006
Location: kolkata
Junior Member
Hi

Actually the file is in UNIX server and it contains a huge lot of data round about 46000 and i need to comapre those values with tha data present in Database.



kindly suggest

Gautam
Re: Comparing contents of a file with data in database [message #208747 is a reply to message #208746] Tue, 12 December 2006 01:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

Actually the file is in UNIX server and it contains a huge lot of data round about 46000
Which type of file.

need to comapre those values with tha data present in Database.

Compare with tables or datafiles.


regards
Taj
Re: Comparing contents of a file with data in database [message #208808 is a reply to message #208746] Tue, 12 December 2006 05:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You'll probably want to consider setting up an external table and use it for the comparison.
Re: Comparing contents of a file with data in database [message #208974 is a reply to message #208808] Tue, 12 December 2006 15:33 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
and then compare the differences...
http://asktom.oracle.com/~tkyte/compare.html
Previous Topic: How to avoid duplication of Cron Jobs
Next Topic: Solaris5.9-->Command HELP
Goto Forum:
  


Current Time: Fri Mar 29 03:21:59 CDT 2024