Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rebuilding Indexes
if you are using 7.3.x you can just rebuild index without droping it
which is a lot faster than drop and build.
if you are droping all the indexes, coalesce the tableSpace which will produce the exact result of dropping the tableSpace and recreating, and it will also keep the quota information. All it does is defrag the tableSpace.
chark
"Jeanne" <jcman_at_SPAMMEBABY.worldnet.att.net> wrote:
>tablespace
Received on Wed Feb 03 1999 - 20:47:48 CST