Re: Script tp parse control file backup ??
- From: "bobmetelsky@xxxxxxxxxxx" <bobmetelsky@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 05 Jul 2004 00:48:46 -0400
>
>>alter database backup controlfile to trace as '/tmp/tracefile.trc';
>>
>>
>>perl -ne 'print unless ((/^#/) or (/^--/)); exit if
>>(/^;/);'</tmp/tracefile.trc
>>
>>
>Mladen,
>
>Thanks for that lovely perl one-liner.
>Unfortunately I can get it to run on my PC. (laptop, Winders XP-PRO) .
>I am just starting with perl (ActivePerl v5.8.4) and the hieroglyphs of
>the language still have me crying into my beer (doesn't taste too bad
>actually)
>Anyway, the error returned is:
> "Can't find string terminator " ' " anywhere before EOF at -e line 1."
>
>
>
His system seems to be using a single quote terminator, my perl install
uses a double quote:
try this
perl -ne " print unless ((/^#/) or (/^--/)); exit if
(/^;/);"<H:\oracle\admin\orcl\udump\orcl_ora_2900.trc>C:\stripped.sql
that really is a nice script Mladen!
thanks
bob
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
