Tablespace defragmentation
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