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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: How to avoid duplication of Cron Jobs
Next Topic: Solaris5.9-->Command HELP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 08 18:29:44 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.