Re: Tablespace defragmentation

unter_at_mecati.mecasoft.ch (Stefano UNTERNAEHRER) writes:

>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 \
>/________________________) (____________________________\

O.K Stefano, heres what you do.

Export all objects held in your fragmented tablespace, drop the tablespace and recreate it and then import your export file bak into the tablespace, and your fragmentation problems will be a thing of the past.

Good luck

Pete. Received on Tue May 23 1995 - 00:00:00 CEST