RE: ORA-00376: file n cannot be read at this time: dba_segments or dba_extents?

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Tue, 2 Mar 2010 11:15:46 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88171D06EE_at_MAIL01KT.seattlepacificindustries.com>

I hope I understood you correctly:

select owner,

	   a.tablespace_name,
       --b.file_name,
       --b.file_id,
	   DECODE( PARTITION_NAME, NULL, segment_name, segment_name || ':' || PARTITION_NAME) segment_name ,
       segment_type


       ,nvl(initial_extent, 0) initial_extent, nvl(next_extent, 0) next_extent


       ,nvl(extents, 0) extents


       ,nvl(a.bytes, 0) bytes


       ,nvl(max_extents, 0)max_extents

from dba_segments a--, dba_data_files b where a.tablespace_name = <your tbs name>   --and a.header_file = b.file_id;

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
  Please consider the environment before printing this e-mail

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre Sent: Tuesday, March 02, 2010 11:02 AM
To: oracle-l_at_freelists.org
Subject: ORA-00376: file n cannot be read at this time: dba_segments or dba_extents?

Hi all,
we lost several datafiles and we needed to find the objects that used to reside in those files ...
I thought that dba_extents is sufficient, but, I found that I should have queried dba_segments instead.

Is the segment header exposed only through dba_segments?

Regards
Dimitre
--
http://www.freelists.org/webpage/oracle-l

��i��0���zX���+��n��{�+i�^ Received on Tue Mar 02 2010 - 13:15:46 CST