Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: compress a tablespace
Depends what you mean by "solution". Yes, it will fix up fragmentation
(though I'd probably stick an 'alter tablespace blah coalesce' in there,
just before you start importing).
But it's not a "cure", in the sense that it will start happening all over again, and one day, you'll have to repeat the procedure.
The only permanent, 100% effective solution for tablespace fragmentation is to ensure that every single extent in a given tablespace is of the exact same size as every other. You can only guarantee to achieve that with 8i's locally managed tablespaces, but there is a MINIMUM EXTENT clause in 8.0 that can help.
Regards
HJR
"@nnib" <annibale_at_ifrance.com> wrote in message
news:9msuqb$k38$1_at_capella.worldonline.fr...
>
> hi,
>
> i've got a tablespace with a big fragmentation.
> does the "export - drop objects - import" is the unique solution ?
>
> thanx
> @nnib
>
>
Received on Sun Sep 02 2001 - 17:08:19 CDT