Wow...I'll have to ask Mr. Ed what it's like to have a
Friday off. Shoot....what it's like to have a day off anytime.

Mmmmmm....Red Stripe is good food.

Kathy Wright wrote:
> 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.
>>
>>
>>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page