Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sql_undo > 2048

Re: sql_undo > 2048

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 18 Feb 2006 14:06:02 -0500
Message-Id: <1140289562l.7065l.0l@medo.noip.com>

On 02/18/2006 01:46:54 PM, Herring Dave - dherri wrote:

>
> I tried using DBMS_LOGMNR.PRINT_PRETTY_SQL when starting logmnr, but
> still some lines get cutoff in mid column name.
>
> Anyone else dealt with this (successfully)? I started playing around
> with using layered SUBSTRs with INSTR on ' ', to grab 2048 of a line, up
> through the next to last word, but after 34+ hrs of no sleep I'm
> starting to lose it.

There si a tool known as pathologically eclectic rubbish lister, written by gentleman named Larry Wall and extended by guys like Randall Schwartz, Damian Conway and Tom Christiansen. I forgot the name of the tool, but it didn't have anything to do with snakes or jewelry. That tool can be used to pretty-print just about anything.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 18 2006 - 13:06:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US