Shell Script --- Delete ORA error from data file

sk005 · #1 (**permalink**) 09-25-2007

Hi All,
I have to make the following changes in shell script:

When the data file is being created, an “ORA” error occurs in it. I have to remove this ORA error from data file and put it in log file.

I am “ –n grip command” to find the ORA error and get the line number,
How do I delete it from the data file?
Please suggest.

jim mcnamara · #2 (**permalink**) 09-25-2007

Code:

grep -v 'ORA'  datafile > newfile
mv newfile datafile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
urgent-extracting block data from flat file using shell script	shirish_cd	Shell Programming and Scripting	4	02-06-2008 09:05 AM
Need Shell Script to upload data from Text file to Oracle database	chandrashekharj	Shell Programming and Scripting	6	03-26-2007 03:21 AM
Shell Script to clense junk data file	rimss	UNIX for Advanced & Expert Users	0	06-07-2006 12:16 AM
Shell Script to Load data into the database using a .csv file and .ctl file	Csmani	Shell Programming and Scripting	3	05-24-2006 08:09 AM
Need Help: Delete a file by Shell Script	r3edi	Shell Programming and Scripting	5	07-11-2005 07:13 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by