RE: Re:adding lines

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_at_libero.it] 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.

>

>-----------------------------------------------------------------------------------------------------------------------

>

--
http://www.freelists.org/webpage/oracle-l