Re: DB defragmentation

Read about using the Import utility. You use this to import the exported
dump file. As long as you didn't specify "COMPRESS=N", (the default is Y), then when you import the dump file, it will compress the extents so that the INITIAL extent will be sized to fit the entire object (table, index, etc). That's (in the most basic sense) it takes to "defrag" a database! Oh -- also make sure you have IGNORE=N on during the import, so that it will recreate the tablespaces.

J.Golovaty wrote:
>
> Instralling Designer 2000 I peacefully reached the end of step 13
> 'Pre-checks before installations' where was written:' 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. I couldn't find the info in other manuals
> I have either(evid. I don't have the whole complect).
> Please help
> JG
Received on Tue Nov 12 1996 - 00:00:00 CET