Re: ora-01555 on 7.3.4.5

Anton Buijs wrote:
> Is the database been stopped and started since the problem occurs?
yes

> a. analyze table X validate structure;
done - same error; we too did an alter session set events to increase the error level, that led us to another inaccessable data block and - by   examining the trace - to another problem, that we have 'malformed' data in some datasets (f.e. we found an attribute containing more bytes than it should have or 'corrupted' date strings)

> b. use the dbverify utility for every file the table and its indexes have
will be next step at an allready planned downtime- unfortunately dbverify on nt is not possible while the datafile is accessed...

martin Received on Sun Aug 25 2002 - 15:28:44 CDT