Good morning Jared,
I believe he used the "getlength' function to find those of 0 (I
assume) length and then used EMPTY_BLOB() to "initialize" it.
Thanks
Susan
________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Monday, October 02, 2006 4:49 PM
To: Susan White
Cc: ORACLE-L
Subject: Re: ORA-600
On 10/2/06, Susan White <swhite@xxxxxxxxxxxxx> wrote:
We have an 8.1.6 database running on Linux. One of the tables
contains two blob columns. About 3 weeks ago, one of the admins decided
to do maintenance on the blob columns by reinitializing those he
determined had no data. At this point, the database started throwing
ORA-600 errors and writing frequently to an smon trace file. We don't
normally support this database, so I just heard about it today.
I'm curious about a couple things:
1) Howd did the admin detemine that the blob 'had no data'?
2) What exactly is 'reinitialize'?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
