Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q:Table Fragmentation. How do I reduce it?
Hi all
Setup: Oracle 7.3.2.3 on HP-UX 10.20
I have a table(s) with lot of extents allocated to it. These extents are small extents. The extents allocated are not all next to each other. Some are but not all. If I drop the table and recreate it, do I get a lot of "free space fragmentation"? How do I reduce the fragmentation of the table? Do I have to export and import the whole tablespace?? ( I have many of these tables with lot of extents allocated to them in the tablespace)
Thanx in ADvance
Rao Uppuluri
(uppuluri_at_XidtX.net -- Please remove X's)
Received on Thu Mar 05 1998 - 00:00:00 CST