ORA-1578 why?

From: Michael Greenberg <michael_at_mapat%mcil.comm.mot.com>
Date: 28 Aug 1994 11:37:23 GMT
Message-ID: <33pstj$6i5_at_delphinium.cig.mot.com>


We are running Oracle version 6.0.36 on an HP T-500 computer running HP-UX 9.04.

Occasionally we receive an Oracle 1578 error. This prevents us from running transactions which need to access the entire table. In order to "recover" access to the entire table we use "alter session set event ...", but we then lose a "blocksize" of data.

We have sent trace files to our Oracle representative, but did not receive a response.

The problem usually appears in an INDEX or rollback segment.

The disks where the .dbf files resided were functional and error-free.

  1. Why does Oracle error 1578 occur?
  2. Can it be prevented?

Thanks is advance,
Michael
(michael_at_mcil.comm.mot.com) Received on Sun Aug 28 1994 - 13:37:23 CEST

Original text of this message