Originally posted by kpate
what will be the best way...
let say i have 10g tablespace after rebuilding indexes it uses 2gig.
can i shrink that tablespace to 5g....
Probably, it depends on where the the indexes physically end up in the TS. Usually they will be rebuilt towards the "bottom" end so this will work - it did for me. (I'm sure someone out there is now busy constructing a counter-example!).
If there are tables in the same TS, this will not work if you have one physically beyond the 5Gb mark.
(Note that you can use "alter index rebuild" to move indexes to a different TS, if that helps.)
Last edited by DaPi; 02-21-2003 at 12:02 PM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote