Re: Packing or freeing datafiles?

On Thu, 05 May 2005 10:19:01 +1000, Snewber <snew_at_snew.com> wrote:

>If the table starts at the beginning of the datafile then moving it once
>won't work, but if you move it twice then it should definitely work.
>
>Also, in regards to indexes, I've found that you should rebuild them
>into another tablespace and then maybe rebuild them back into the
>original tablespace if needed, however leaving them in the new
>tablespace would be quicker if that isn't a problem for you.
>
>Ideally you should just reverse engineer your indexes, then drop them
>and recreate them (if possible). This is harder than moving them twice,
>but twice as quick. I guess it depends on whether you need to have them
>online at all times.

This advice is absurd.
There is no need to rebuild indexes twice, let alone drop them and recreate them. You won't gain anything by doing so. Also it is absurd (and you also don't provide any proof) you should move tables twice.

--
Sybrand Bakker, Senior Oracle DBA