Re: Please Help

In article: <3i466h$i01_at_news.cis.nctu.edu.tw> Vinay <vinay_at_wslvax1.wipsys.soft.net> writes:
>
> 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
>
>

-- 

	question 1
	
		seem to be some serious corruption here, because you
are doing an export at the time, and the table causing
the corruption changes,  the corruption could be in the temporary
tablespace, if you are lucky :-)

	question 2

	The read consistancy for the master cursor cannot be maintained 
because the extents in the rollback segment that it needs have been overwritten
by another transaction. try removing the commit after ever 100 records. However
that may only cause the error number to change.

	Try larger rollback segments.


---
	Tim London			phone :	+44 753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk