Re: DB defragmentation

> "J.Golovaty" <golovaty_at_crs.ch> writes:
 ..:' if SYSTEM
> tablespace is fragmented you'd rectify it by perfprming full DB export
> and re-import...'
> So I exported it. But what to do now? How to merge the fragments
> togeather Manual doesn't say....

Normally you can use parameter COMPRESS=Y in your export to cause allocation of sufficient initial extent space for all data when you import. That requires dropping the object so the import can re-create it.  But the system tablespace is not normal. Export and import don't move objects owned by SYS, they merely cause those objects to reflect results of the operation. And I'd hesitate to drop anything SYS owns.

• Paul de Anguera, City of Seattle / HRIS