Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> rebuild indexes with autoextend on databasefiles?
What happens if one would try to rebuild all indexes in an index tablespace
with no free space and with autoextend enabled for the databasefiles? Would
the databasefiles be extended to twice the original size (to hold twice the
data during rebuild) and then hold that size? Should one add a new temporary
datafile to get enough space for rebuild and then delete it afterwards? If
so, is it necessary to disable autoextend on the other databasefiles? Is
there another way?
Rgrds,
Anders
Received on Wed Aug 22 2001 - 06:20:21 CDT