Re: data manipulation of a large unix file

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 22 Jan 2004 07:29:28 -0800
Message-ID: <F001.005DDD9E.20040122072928@fatcity.com>

Ryan,
Could you cat the second file on to the end of the first file and have the data load successfully?
cat file2 >> file1

How about a second box to perform the editing of the data file. Something that resource intensive and manditory should not have a problem getting funded.
Ron

>>> ryan.gaffuri_at_cox.net 01/22/2004 9:59:41 AM >>>
We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable).

ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: <ryan.gaffuri_at_cox.net 
  INET: ryan.gaffuri_at_cox.net 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Jan 22 2004 - 09:29:28 CST