Re: sed command
Date: Fri, 15 May 2009 12:49:04 +0530
Message-ID: <b081c0a50905150019g7558d350o705833a162cd4a2d_at_mail.gmail.com>
hi Michael ,
Here my scenario is also like that which you have mentioned bellow. this is my entry in the batch file .
first we are creating the sql commands from a index file , and then we are formatting that index file by removing all the rem etc.
imp system/manager file=emp.dmp fromuser=scott touser=hr indexfile=objects.sql log=objects.log 2>&1 | %TEE% -a %LOGFILE%
rem -----------------------------------------------------------------------------rem format the objects.sql file to obj.sql
rem -----------------------------------------------------------------------------
del obj.sql 2>&1 | %TEE% -a %LOGFILE%
sed "s/REM //" objects.sql | sed "/rows/d" | sed -e "s/#.*//" -e "/^$/ d" |sed "s/CONNECT %OraSchemaOwner%//" | sed "1a spool obj.log" | sed "$a\ " | sed "$a\ spool off" | sed "$a\ exit;" >> obj.sql 2>&1 | %TEE% -a %LOGFILE%
my case is in the index file a a command is created like the below one
REM ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT
REM sysdate
REM
REM
REM
REM ) ;
REM ... 260000 rows
it is formatting into
ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT sysdate
) ;
when this command runs ,it is comming like this
SQL> ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT
2 sysdate
3
SQL> SQL> SQL> ) ;
SP2-0042: unknown command ") " - rest of line ignored.
AND MY REST OF THE COMMANDS IN THE BATCH FILE IS ABORTED.. so i need to include a proper formatting command to ignore the lines in-between this one
ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT sysdate
) ;
and need to merge with the );
plz suggest some commands to do the above task which i need to include in this
sed "s/REM //" objects.sql | sed "/rows/d" | sed -e "s/#.*//" -e "/^$/ d" |sed "s/CONNECT %OraSchemaOwner%//" | sed "1a spool obj.log" | sed "$a\ " | sed "$a\ spool off" | sed "$a\ exit;" >> obj.sql 2>&1 | %TEE% -a %LOGFILE%
Thanks and Regards,
Mohammed
On Fri, May 15, 2009 at 11:47 AM, Michael Garfield Sørensen
<mgs_at_cedet.dk> wrote:
>
> http://gnuwin32.sourceforge.net/packages/sed.htm = Sed for Windows
>
> Works like a charm:
> ------------------------------------------------------------------
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
>
> C:\>type sample.sql
> REM SELECT * FROM DUAL;
>
>
> C:\>which sed
> C:\Program Files\GnuWin32\bin\sed.EXE
>
> C:\>sed "s/REM //" sample.sql
> SELECT * FROM DUAL;
>
> ------------------------------------------------------------------
>
> HTH
> Michael Garfield Sørensen, CeDeT
>
>
> Quoting Niall Litchfield <niall.litchfield_at_gmail.com>:
>
>> sed is a unix command line tool. You can get various replacements using
>> cygwin or others - if sed is a gnu utility there will likely be a windows
>> binary for it, or you can reformulate your problem as a business problem
>> rather than a technology issue - for example I need to remove all
>> occurrences of a string from a file, preferably using the command line. I'd
>> just use ctrl-h in write to do string replacement in a text file fwiw.
>>
>> Niall
>>
>> On Fri, May 15, 2009 at 6:35 AM, Mohammed Mehraj hussain <
>> mhdmehraj_at_gmail.com> wrote:
>>
>>> hi all ,
>>>
>>> i need to format a file using the sed command on windows .
>>>
>>> For example iam running this command in my comman prompt of win xp.
>>>
>>> D:\sample> sed "s/REM //" sample.sql
>>>
>>> 'sed' is not recognized as an internal or external command,
>>> operable program or batch file.
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 15 2009 - 02:19:04 CDT