Re: Tablespace level defragment in V7?

Have you tried exporting the tables in the tablespace (compressing the extents), dropping the tables, and then importing them back in. This will compress the extents when you bring them back in so that each table will have one contiguous extent. You have to be careful in a tight tablespace though. You should always export the large tables individually first, and all the small ones in a separate export file. Then you must import the large objects first so they have enought room in the tablespace to make one contiguous extent. You must also make sure that your datafiles are large enough so the object can create one extent across one datafile. If the largest datafile in the tablespace is too small, then that datafile needs to be enlarged so that the largest object(s) can be created in that file. Once again, import starting with the largest object first and you should be okay.

If more questions feel free to email me.

Hope this helps.

On Mon, 13 Sep 1999 23:43:05 +0800, KC <kcheung_at_poboxes.com> wrote:

>Hi all,
>
>Is it possible to perform tablespace level defragmentation in DBMS 7.3 ?
>
>Thanks,
>Kevin
>

Rob Calfee
DBA
rcalfee_at_incsystem.com Received on Mon Sep 13 1999 - 13:00:35 CDT