Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to estimate space saved with index reuild
export the database, indexes are not exported.
Regards,
Sybrand Bakker, Oracle DBA
"Allan Plesniarski" <aplesnia_at_my-deja.com> wrote in message
news:9133dq$jik$1_at_nnrp1.deja.com...
> Hi, we have a tar|gzip of a production database that takes too long.
> One suggestion for shortening the time is to rebuild the indexes,
> thereby removing the deleted nodes and shortening the tar|gzip time.
> In order to do a cost/benefit analysis, how does one estimate the
> amount of space freed after rebuilding an index?
>
> Any other way to speed up a tar|gzip?
> Database size is approx 50 GB.
>
> Thanks,
> Allan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 11 2000 - 12:01:51 CST