Re: Shrink Many Files

From: Antoine BRUNEL <antoinebrunel_at_nospam_yahoo.fr>
Date: Wed, 12 Jan 2005 21:11:42 +0100
Message-ID: <41e58442$0$18706$79c14f64@nan-newsreader-07.noos.net>

Hi from Paris

a litlle select on DBA_EXTENTS, grouping by FILE_ID and with max (BLOCK_ID+BLOCKS) will give max used space on each db files...

<cdavis10717_at_comcast.net> a écrit dans le message de news: 1105558713.668279.29440_at_z14g2000cwz.googlegroups.com...
>I have a tablespace comprised of 450 files.
>
> I recently dropped a 400GB table from this tablespace. The table has
> 27000 extents.
>
> I'd now like to re-size each of the 450 files to its smallest possible
> size.
>
> I'd like to have a script that can determine each file's smallest
> possible size and generate the RESIZE syntax, which I will spool and
> run.
>
> Does anyone have a query that produces this required syntax?
> Thanks.
>
> C
>
Received on Wed Jan 12 2005 - 14:11:42 CST