RE: Out of topic :Compare 2 data files in unix

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Wed, 19 Jun 2002 08:03:28 -0800
Message-ID: <F001.004814E4.20020619080328@fatcity.com>

Sounds like this might be a good opportunity for you to explore the new 9i External Tables feature (assuming you have 9i). You won't have to use SQL*Loader to load the data into tables using this method; the data remains in OS files but can be queried using SQL (MINUS, etc.).

Search the Oracle docs or check out "Oracle 9i: New Features" by our very own Robert Freeman (Oracle Press, 2002).

Of course, this may be overkill if this is a one-time job. In that case, I'd suggest using a tool like SlickEdit to compare the files.

HTH, david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Office (919) 466-6723
Pager 8666864767_at_archwireless.net
Fax (919) 466-6783
http://www.arsenaldigital.com/  

• NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.

-----Original Message-----
[mailto:cosltemp-g.manoj_at_orbitech.co.in] Sent: Wednesday, June 19, 2002 3:13 AM
To: Multiple recipients of list ORACLE-L

Hi,

    I have 2 data files file1 & file2.
I want to get all those records which are present only in file2 & not in file1.
Also want records which are present in both ,separately. I tried to use diff , but not entirely familiar with the diff options.

Thanks
Manoj.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 19 2002 - 11:03:28 CDT