Defragmenting Tablespaces
From: Krishnan Vaidyanathan <cc70155_at_vantage.fmrco.com>
Date: Wed, 26 Oct 1994 13:37:40 GMT
Message-ID: <1994Oct26.133740.657_at_fmrco.uucp>
Date: Wed, 26 Oct 1994 13:37:40 GMT
Message-ID: <1994Oct26.133740.657_at_fmrco.uucp>
The free extents in a tablespace are stored in the table fet$. Each record identifies each free extent the start address and the end address. Deleting rows from this table and updating other corresponding rows to appropriate addresses defragments the tablespace. I have used this without any problem on temporary tablespaces which tend to get fragmented very often.
Krishnan
PS: Try this first on a database which u can crash. This approach
is obviously unsupported.
--- Krishnan Vaidyanathan 320 Salem St Atp # 16 Medford MA 02155 Voice : (617) 395 5692 Internet: cc70155_at_vantage.fmrco.comReceived on Wed Oct 26 1994 - 14:37:40 CET