Re: code to load tracefile into CLOB?

From: "Tim Gorman" <tim@xxxxxxxxx>
To: jeremy.schneider@xxxxxxxxxxxxxx, Oracle-L@xxxxxxxxxxxxx
Date: Tue, 16 Aug 2011 23:08:06 +0000

Jeremy,

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@xxxxxxxxxxxxxx]
Sent: Tuesday, August 16, 2011 04:39 PM
To: Oracle-L@xxxxxxxxxxxxx
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

Follow-Ups:

Re: code to load tracefile into CLOB?
From: Jeremy Schneider

Re: code to load tracefile into CLOB?

Other related posts: