-
free up tablespace
Hi,
I initially allocated 1000Mb space on my table EMP in USERS tablespace,
when I loaded the actual data it consumed only 800Mb.
How do I release the 200Mb unused space?
Thanks
-
-
how dear?...is the command right?
Alter tablespace datafile resize 800M;
-
Well, if you gave allocated the space to the EMP table ( i.e EMP have extents of 1000Mb but only 800 of them are used, and no more HAVE EVER been used, then
alter table emp deallocate unused;
should return the free space back to the tablespace.
Further, if you want to resize the file, I believe the command should be something like
aler database datafile '....' size 800M
Good luck
-
thanks dear for being so accomodating... I give you and davey 1000 pogi points of good karma
Last edited by jennifer2007; 02-12-2007 at 04:26 AM.
-
... *karma - sounds to me like you have been influenced by hindu philosophy?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
well i've heard it in camfrog.com...oops sorry for the spam, moderator
-
well i've heard it in camfrog.com...oops sorry for the spam, moderator
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|