Can someone please tell me if there is a way to find the first record type in a tablespace?
In other words I want to be able to find the name of the first physically stored record in a tablespace that may contain many tables.
This is an attempt at it:
select segment_name, block_id from dba_extents where
(extent_id = (select min(extent_id) from dba_extents where tablespace_name = 'ICMS_DATA_TS')
and segment_type = 'TABLE' and tablespace_name = 'ICMS_DATA_TS')
order by block_id;
SEGMENT_NAME BLOCK_ID
--------------------------------------------------------------------------------- ----------
ICMSSCMT 2
ICMSBHDR 2
XISYS_ICRHDR_KEY 2
XISYS_ICALS_PROD 1282
ICMSPOGR 1282
ICMSGSPC 1282
XISYS_ICHDR_COMP 2562
ICMSSTOR 2562
ICMSATYP 2562
XISYS_ICO_STATUS 3842
AMOSGUSE 3842
etc..
John Baylis
DBA / Systems Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada
