Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> rebuild indexes with autoextend on databasefiles?

rebuild indexes with autoextend on databasefiles?

From: Anders Blomkvist <anders.blomkvist_at_nokia.com>
Date: Wed, 22 Aug 2001 11:20:21 GMT
Message-ID: <VzMg7.1433$Kl.28251@news2.nokia.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US