Or you could just do
alter datafile 'path/path/path/datafile_name.dbf' resize 14000M;

If you get an unable to shrink because you have extents out further than the 14gig, you will have to do what Chris suggests.

No biggie either way, really!
Have fun and Happy Friday!

Kathy

>>> "Chris Pope " <oracledba-ezmlmshield-x24983806.[Email address protected] 11/30/2007 9:08:09 AM >>>
You could...

create a new tablespace, move everything in Users to it ,
drop Users and recreate it , then move everything back.




Oracle LazyDBA home page