Re: Fragmentation of ORACLE DBMS
Date: 1995/09/09
Message-ID: <42sk7h$1tg_at_tst.hk.super.net>#1/1
Joakim Westman <edtwest_at_kiay3.ericsson.se> wrote
>When creating/dropping tablespaces in ORACLE RDBMS v.7.x (HP-UX) one will
>after a while reach a state where the index SYS.I_OBJ2 in tablespace
>system cannot be extended. It has been said to me that old (dropped)
>tablespaces (e.g. it's fysical diskspace) cannot be reused, hence
>fragmentation occurs. The database I am concerned with is used for
>development and the managament of tablespaces (CREATION/DROP) is a
>frequent activity.
>
I think you're looking for some online de-fragmentation methods for tablespaces, right ?
It isn't easy, be frank! But one way you can try is to create a really "big" table using the remaining space available in the tablespace, then drop it. Bad news is you won't gain very much if the tablespace is too fragmented or disallow you from creating a real big table.
Best way to defragment a tablespace is to recreate it, for sure!
Rgds. Received on Sat Sep 09 1995 - 00:00:00 CEST