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');

That is not what I wanted. I used (Block 262144 was the one):

select * from dba_extents
where block_id=
(select max(block_id) from dba_extents where block_id<262144);

BTW, the error came from a bug in Oracle 8.0.5 for Solaris. I installed the patch and everything works fine now.

Regards,

Knut Received on Wed May 16 2001 - 11:18:01 CDT