Please Help

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 Received on Sat Feb 18 1995 - 08:04:49 CET