Re: Urgent: ORA-01115 in alert.log

a)
select * from dba_segments where tablespace_name in (select tablespace_name from dba_data_files where file_name =
'/erp_b_8/oradata/MTPRT/dbs/apps02MTPRT.ndx');

Knut Talman schrieb in Nachricht <3B00F413.A15F6156_at_mytoys.de>...
>Hi there,
>
>since some days I have a message in my alert.log, saying
>that:
>
>Tue May 15 11:06:02 2001
>Errors in file
>/opt/app/oracle/product/MTPRT/admin/MTPRT/bdump/mtprt_smon_12839.trc:
>ORA-01115: IO error reading block from file 16 (block # 262144)
>ORA-01110: data file 16: '/erp_b_8/oradata/MTPRT/dbs/apps02MTPRT.ndx'
>ORA-27072: skgfdisp: I/O error
>SVR4 Error: 2: No such file or directory
>Additional information: 262143
>
>
>My questions:
>
>a) How do I find out, which index is using the block?
>
>b) When I know a), will a drop index and create index solve the problem?
>
>c) Why is there a message: SVR4 Error: 2: No such file or directory?
>
>
>Thank you in advance.
>
>Regards,
>
>
>Knut
Received on Wed May 16 2001 - 08:42:05 CDT