RE: how to find the "last" object in a data file?
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <HELMUT.DAIMINGER@xxxxxx>
- Date: Thu, 21 Oct 2004 12:06:48 +0200
Hi
In dba_extents you find the position (block_id) and the size (blocks) of =
each extent...
Chris
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Daiminger,
>Helmut
>Sent: 21 October 2004 12:02
>To: LazyDBA.com Discussion; oracle-l@xxxxxxxxxxxxx
>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
>
>--
>//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
