Tablespace defragmentation

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/05/17
Message-ID: <D8pxo4.AJB_at_mecati.mecasoft.ch>#1/1


Hi netters!

I would like to defragment all my tablespaces.

0- About the SYSTEM tablespace, I've posted an

   article monday, but I have received no help    since now...

1- temporary tablespace

   The temp tablespace doesn't contains data, but I    have actually a Free Space Fragmentation Index (FSFI)    with value 23.8094802, so I need to defragment it.    How to do? Simply drop tablespace temp, create    tablespace temp? What about the users who have    this tablespace defined as temporary tablespace?

2- index tablespaces

   At the moment no problem (FSFI = 100, wow!).    But in case I have to do it, what to do?    I can try to guess: drop indexes, drop tablespace inx01,    create tablespace inx01, create index using inx01.    Right? Others solutions?

3- data tablespaces

   Also have to do it. FSFI = 23.1302211    Export compress=Y + import?
   Have to drop/create all the tables before to import?

Very grateful for any help!
Stefano

--
                       ____________________________
______________________|    Stefano Unternaehrer    |__________________________
\  Mecasoft SA        |         Oracle DBA         | fax:    +41 93 335 507  /
 \ 6600 Muralto       |     and  PL/SQL, Pro*C     | voice:  +41 93 337 444 /
  \                   |     C, XWindow & Motif     |                       /
  /                   |     Software Developer     | email:                \
 / Switzerland Europe |____________________________|  dba,unter_at_mecasoft.ch \
/________________________)                      (____________________________\
Received on Wed May 17 1995 - 00:00:00 CEST

Original text of this message