RE: Re:adding lines
- From: Kjetil Strønen <kjetil@xxxxxxxxxx>
- To: Noor.Mulla@xxxxxx
- Date: Mon, 14 Dec 2009 14:14:19 +0100
On Mon, 2009-12-14 at 17:34 +0530, Noor Mulla wrote:
> Alessandro,
>
> Thanks...
>
> In your_file_list I have to list all the ctl files seperated by comma.
> How to run this…
> How to add the other caluse as in the trailing mail(bold/red).
Taking a sed-approach, I'd do:
----
for FILE in `ls -1 *.ctl`
do
mv ${FILE} ${FILE}.bkp_`date +%Y%m%d`;
cat ${FILE}.bkp_`date +%Y%m%d` | \
sed -e "s/^load\ data/unrecoverable\nload\ data/g" \
-e "s/^infile\ '/infile\ '\/new\/full\/path\//g" \
-e "s/^into\ table/append\ into\ table/g" > ${FILE};
done
----
--Kjetil
> -----Original Message-----
> From: Alessandro Vercelli [mailto:alever@xxxxxxxxx]
> Sent: Monday, December 14, 2009 5:21 PM
> Subject: Re:adding lines
>
> Hi Noor,
>
> awk should be the best tool for the job, but I don't know it much so
> the following bash could work for your needs:
>
> for FILE in "<your_file_list>"
> do
> vi -c "1,\$s#infile '#infile
> '/DDUMPS/sybase_dump/out/DATACITI_MASTER/Oracle/#g|wq" $FILE
> done
>
> The instruction between "do" and "done" must be on a single line.
>
> Make a safety copy of your scripts before doing.
>
> Hope it helps,
>
> Alessandro
>
> >Hi All,
> >
> >By using awk or any unix commands, can we change all ctl files .We
> have 25 such files which is subject to change.
> >
> >
> >load data
> >infile 'DATACITI_MASTER.dbo.aspc_defaultdb.dat' "str '<EORD>'"
> >into table DATACITI_MASTER.aspc_defaultdb
> >fields terminated by '<EOFD>'
> >trailing nullcols
> >(
> >virtualid ,
> >host CHAR(255)
> >)
> >to
> >
> >We need to change it to below by adding data in bold(red) to all
> existing ctl files.
> >
> >UNRECOVERABLE
> >load data
> >infile
> '/DDUMPS/sybase_dump/out/DATACITI_MASTER/Oracle/DATACITI_MASTER.dbo.aspc_defaultdb.dat'
> "str '<EORD>'"
> > append into table DATACITI_MASTER.aspc_defaultdb
> >fields terminated by '<EOFD>'
> >trailing nullcols
> >(
> >virtualid ,
> >host CHAR(255)
> >)
> >
> >
> >Please provide me the solution asap.
> >
> >Thanks & Regards
> >Noor
--
//www.freelists.org/webpage/oracle-l
Other related posts:
