Re: Defragmentation of SYSTEM TABLESPACE

First, congrats on finding a customer that will always need your consulting services! Now, to the most common solution:

You need to build the correct tablespaces and correctly migrate the tables to them. Then you need to export the entire database, recreate it, and reimport. When everything reimports to the new locations, the SYSTEM tablespace will only contain its own objects, and it will be defragmented. The new tablespaces will contain only the appropriate objects (assuming you migrated them there in the first place).

Since SYSTEM is, well, the system tablespace, it cannot be defragmented without dropping and recreating the database.

Matt...
(mreagan_at_fast.net)

arpege <arpege_at_imaginet.fr> wrote in article <34618E00.7552_at_imaginet.fr>...
> We do have some curstomers that only have (bad design) a single
> tablespace (SYSTEM). Is there any possibility to defragment it ?
>
> Best Regards (arpege_at_imaginet.fr)
>
  Received on Thu Nov 06 1997 - 00:00:00 CST