Re: ORA-600

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: swhite@xxxxxxxxxxxxx
  • Date: Mon, 2 Oct 2006 14:48:53 -0700

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
  • References:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006