RE: how to find the "last" object in a data file?

Hi

In dba_extents you find the position (block_id) and the size (blocks) of = each extent...

Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daiminger,
>Helmut
>Sent: 21 October 2004 12:02
>To: LazyDBA.com Discussion; oracle-l_at_freelists.org
>Subject: how to find the "last" object in a data file?
>
>Hi!
>
>I do have a tablespace that consists of four datafiles. Data file =
number
>4 is 20 GB in size, but only 2 GB of those 20 GB are used.
>
>I use=3D20
>
>select segment_name from dba_segments where relative_fno=3D3D17 and
>segment_type=3D3D'TABLE'
>
>to find all the tables in that specific datafile. I got the =
relative_fno
>from dba_data_files.
>
>But how do I know the table that is the "last" segment in the datafile
>that prevents me from shrinking it? I assume that there is just one or
>two tables in the file that need to be moved to that I can shrink it by
>about 15 GB.
>
>Any ideas?
>
>This is 9.2 on HP-UX 11i.
>
>Thanks,
>Helmut
>
>--
>http://www.freelists.org/webpage/oracle-l

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