how to truncate previous area after table/index move

L

lemdog

New Member
Hey all,

just wondering, is there a way to truncate a storage area after a group of tables/indexes have been moved off to thier own respective extents/areas?

without having to do a total revamp and rebuild structurally, i am just looking to see if there is a way to shrink the size of the space these tables/indexes once took up.

any info would be helpful...

thanks
 
Thanks Tom, thats kind of what i had in mind as well.

part 2 of the question may be: how to safely remove un-used storage extents now that the data/indexes have been moved? (some tables/indexes still do reside in original area)
 
Just a side note, but if you truncate an area, all data in that area is removed, so you cant use it to free up used space after a table/index move and leave other data there.
If you have unused (data) extents, you can always remove them with: "prostrct remove db-name extent-token storage-area". If there is data in them it will give you an error, database needs to be offline though.

Regards,
Casper.
 
You must log in or register to reply here.
Back
Top