It depends on where the last segment appears in the datafile, use OEM to
map the tablespace and see if a reorg must be done first.


Rick Weiss
Oracle Database Administrator
Montana Department of Labor & Industry
Centralized Services Division
Technical Services Bureau
1327 Lockey
P.O. Box 1728
Helena, Montana 59624-1728
(406) 444-9628
[Email address protected]

-----Original Message-----
From: James Oddo
[mailto:oracledba-ezmlmshield-x81213225.[Email address protected]
Sent: Thursday, April 28, 2005 9:33 AM
To: LazyDBA Discussion
Subject: Why cant I shrink this table space.....

Ok 9.2.0.5 locally managed table space table space usage 2.1 GB data
file size 9GB why cant I get this sucka to shrink...........


Oracle LazyDBA home page