Re: sql_undo > 2048

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