Well, well, well!
It's Kathy Wright! Hehe. How have you been? I was on vacation (17
Nov to 29 Nov)! Now, why did I come back to work today (Friday, 30 Nov
2007)? I dunno! Hehe. I was still sleeping but I saw "Red Stripe"!
Oh my! Phew! Ouch! I am now "wide awake"! hehe.

Ahhhhhhhhh, yes! It's Fridayyyyyyy! Partyyyyyyyyy!


A "Red Stripe" for you! hehe.


Have a great Day and Weekend!






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Kathy Wright
[mailto:oracledba-ezmlmshield-x76213628.[Email address protected]
Sent: Friday, November 30, 2007 2:30 PM
To: LazyDBA Discussion
Subject: Re: Users tablespace

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