Re: Script tp parse control file backup ??

From: <bobmetelsky_at_comcast.net>
Date: Mon, 05 Jul 2004 00:48:46 -0400
Message-ID: <40E8DDAE.70208@comcast.net>

 >

>>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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun Jul 04 2004 - 23:45:39 CDT