Re: Please Help

I've seen this several times before, and each time the problem was eventually followed by a disk failure. Keep a close eye on your hardware.

You probably want to do a rebuild in case you've got a corrupted data dictionary.

On 18 Feb 1995, Vinay wrote:

> Hi,
>
> Can anybody answer the following two questions?.
>
> Question 1 :-
>
> One of my friend has got ORA-1578 error while exporting the DB.
> Message is "Datablock corrupted"
> In what point of time the error will occur?.
> He is also wondering about the error. Each day while exporting
> the error comes on different tables not on the same table
> which was errored out by previous export. His OS is UNIX.
> But while analysing the hard disk for bad sectors, the result
> is nil. Please clarify at waht place, where, and why the
> ORA-1578 error message occurs?.
>
> Question 2 :-
>
> I am getting an oracle error which has to do with rollback segments.
>
> ORA-01555 snapshot too old (rollback segment too small)
>
> The program that we are running opens one master cursor and then opens
> 21 related cursors based on the fetch from master cursor. The program
> deletes from the 21 tables on which the cursors have been declared. We
> are giving a commit after every 100 records.
>
>
> We are running ORACLE ver 7 on OpenVMS ver 6.1.
>
> Regards
>
>

                 ,,,
                (o o)
 +----------oOO--(_)--OOo-----------+   
 |                                  |Tom Mudd gers_at_brisbane.DIALix.oz.au
 |         No Worries Mate          |A displaced San Diegan living down
 |                                  |under. The 49rs got lucky.
 +----------------------------------+