| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: exp : compacting tablespaces
On 4 Nov 1998 16:23:09 GMT, luc van der veurst <lucv_at_az.vub.ac.be.>
wrote:
>Hello,
>
>We archived some data and after deleting the rows, we wanted
>to compress the tablespace.
>
>I exported the data (after dropping all indexes), dropped and
>recreated the tablespace and imported the data again.
>
>I didn't see any gain of space.
>
>The version of the exp utility is Release 7.2.3.0.0.
>I pressed return when exp asked the question 'compress extents'
>because 'yes' was shown as the default answer.
>
>Could it be possible that this is wrong and that I had to
>explicitly type 'yes' ?
No, it's just the other way around - you should have typed 'no' if your goal was to gain some space in you tablespace. The 'compress extents' option in exp doesn't mean the extents will be compressed to their minimum needed size to hold all the data, it simply means that all extents of a segment will be joined together in the single extent, sized as a sum of all original extents sizes.
If you want to free some unused space from original extents, then you have to precreate the segments manualy before the import or use compress=no when performing import.
>Thanks for your help,
>Luc.
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
 |
 |