Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table defragmenting
On 08 Oct 1999 11:57:10 -0400, buzzwang_at_churchill.ourvillage.com
(David F. Newman) wrote:
>Hi,
> As near as I can tell, the only way to defragment
>a table is to export with compress extents turned on,
>drop the object or schema, and import back into the database.
>So what do people do with 24x7 databases? The alter
>index rebuild command has come in very useful. I've been
>able to write a script that finds all of my indexes with
>more than 1 extent, calculate a new initial extent + 40%
>and calculate a new next extent 20% of initial. I wish
>dealing with tables was as easy. Anyone have any advice?
I agree 100% with what Connor have said about this subjects (including the suggested URL for excellent whitepapers).
But just to answer your direct question:
Yes, in 8i rebuilding the tables is just as easy as it was rebuilding indexes in pre-8i. The command is "ALTER TABLE MOVE ....".
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)