Shrink Many Files

From: <cdavis10717_at_comcast.net>
Date: 12 Jan 2005 11:38:33 -0800
Message-ID: <1105558713.668279.29440@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 - 13:38:33 CST