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. > >----------------------------------------------------------------------------------------------------------------------- > -- //www.freelists.org/webpage/oracle-l