RE: Re:adding lines

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: