| building index online for oracle 8i [message #52268] |
Thu, 11 July 2002 14:36  |
Xin
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
Does anyone know if building index with online mode will require more tablespace than traditional index building?
If so, how do I estimate enough tablespace before issue the command??
Thanks
|
|
|
|
| Re: building index online for oracle 8i [message #52274 is a reply to message #52268] |
Thu, 11 July 2002 18:17  |
P
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
Are you talking about the Enterprise edition feature where you can rebuild an index online without locking it excusively?? or just an index rebuild
Anyway you will need twice the size of your index in teh tablespace while it rebuilds
|
|
|
|
| Re: building index online for oracle 8i [message #52290 is a reply to message #52274] |
Fri, 12 July 2002 07:33 |
Xin
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
|
Yes, I am talking about Enterprise edition feature where you can rebuild an index online without locking it excusively. Do you mean it takes the twice the size of index in the tablespace for building it online, or just a regular rebuild? For regular rebuild, we don't need that much space.
|
|
|
|
| Re: building index online for oracle 8i [message #52312 is a reply to message #52274] |
Sun, 14 July 2002 17:43 |
P
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
|
As i understand the online rebuild uses quite a lot of space. It must maintain a copy of current index while the operation is taking place, plus sorting space. So a rebuild will require at least twice the space while the operation takes place.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
