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

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 02 Mar 2010 20:01:41 +0100
Message-ID: <4B8D6095.40706_at_gmail.com>

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

Received on Tue Mar 02 2010 - 13:01:41 CST