find first record in tablespace?

From: Baylis, John <JBaylis_at_mail.canfor.ca>
Date: Mon, 19 Feb 2001 16:10:30 -0800
Message-ID: <F001.002B8445.20010219154556@fatcity.com>

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 Received on Mon Feb 19 2001 - 18:10:30 CST