RE: Re:adding lines
- From: Noor Mulla <Noor.Mulla@xxxxxx>
- To: Alessandro Vercelli <alever@xxxxxxxxx>
- Date: Mon, 14 Dec 2009 17:34:09 +0530
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).
Thanks
Noor
-----Original Message-----
From: Alessandro Vercelli [mailto:alever@xxxxxxxxx]
Sent: Monday, December 14, 2009 5:21 PM
To: Noor Mulla
Cc: oracle-l
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
>
>
>DISCLAIMER:
>-----------------------------------------------------------------------------------------------------------------------
>
>The contents of this e-mail and any attachment(s) are confidential and
>intended for the named recipient(s) only.
>It shall not attach any liability on the originator or HCL or its affiliates.
>Any views or opinions presented in
>this email are solely those of the author and may not necessarily reflect the
>opinions of HCL or its affiliates.
>Any form of reproduction, dissemination, copying, disclosure, modification,
>distribution and / or publication of
>this message without the prior written consent of the author of this e-mail is
>strictly prohibited. If you have
>received this email in error please delete it and notify the sender
>immediately. Before opening any mail and
>attachments please check them for viruses and defect.
>
>-----------------------------------------------------------------------------------------------------------------------
>
Other related posts:
