Re: Tablespace level defragment in V7?

From: Ben Ryan <benryan_at_my-deja.com>
Date: Mon, 13 Sep 1999 21:22:29 GMT
Message-ID: <7rjpu7$9jt$1@nnrp1.deja.com>

In article <37DD1B89.75B86A04_at_poboxes.com>, KC <kcheung_at_poboxes.com> wrote:
> Hi all,
>
> Is it possible to perform tablespace level defragmentation in DBMS 7.3
?
>
> Thanks,
> Kevin
>

If you are just trying to "join" adjacent free space extents then use ALTER TABLESPACE name COALESCE;

If your free space extents are interlaced by used extents then see the previous reply about exporting and then re-importing all tables and indexes which use the tablespace.

To see how your tablespace is fragmented (remembering that tablespace is made up from one or more datafiles) use two SELECTs on dba_free_space and dba_extents in a UNION with an ORDER BY block_id.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 16:22:29 CDT