Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to find the "last" object in a data file?

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

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 21 Oct 2004 12:06:48 +0200
Message-ID: <2CF83791A616BB4DA203FFD13007824A018D0E7E@MSXVS02.trivadis.com>


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
Received on Thu Oct 21 2004 - 05:02:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US