LOL on the blood warming!
By the way, I think you and I deserve red stripes cuz it looks like Mr. Ed took Friday off!
Kathy


>>> "Chris Pope " <oracledba-ezmlmshield-x89618087.[Email address protected] 11/30/2007 12:43:21 PM >>>
Very true. My resizing luck hasn't been very good so I don't
even bother anymore. Plus...nothing like a little
tablespace re-org to warm the blood.

Kathy Wright wrote:
> 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