Re: code to load tracefile into CLOB?

Given all the complexities involving LOBs in general, why not load the tracefile line-by-line into a table with each line is a row, thus using a VARCHAR2 column for the text of the line? Easier to load, easier to manage, easier to index, easier to retrieve?

Just my $0.02?

-Tim

-----Original Message-----

From: Jeremy Schneider [mailto:jeremy.schneider_at_ardentperf.com] Sent: Tuesday, August 16, 2011 04:39 PM
To: Oracle-L_at_freelists.org
Subject: code to load tracefile into CLOB?

Just wondering... does anyone out there have a snippit of code thatwill load a 10046 trace file from bdump or udump into a LOB? Justlooking for a quick and dirty way to give some developers access totracefiles (without requiring unix logins). Didn't see any code sampleswith a quick google search, so I'm about to code it myself - justthought I'd ask first.-Jeremy-- http://www.ardentperf.com+1 312-725-9249Jeremy SchneiderChicago--http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 16 2011 - 18:08:06 CDT