| Oracle 8 rebuild index [message #162365] |
Thu, 09 March 2006 21:20  |
marco118
Messages: 16
Registered: March 2006
|
Junior Member |
|
|
Hi all
I am a rookie,
I just want to know what is the result for disk usage if I rebuild the index? will it increase disk space usage or less space usage? thanks!
Best Regards
Marco118
|
|
|
|
| Re: Oracle 8 rebuild index [message #162387 is a reply to message #162365] |
Fri, 10 March 2006 00:28  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
An index rebuild that uses the same parameters will generally take less space. How much less depends on the amount of block splitting that has occurred. There is a infinitessimally small chance that it will take more space, and even then, it would be no more than the PCTFREE setting on the index (probably 10%).
_____________
Ross Leishman
|
|
|
|
| Re: Oracle 8 rebuild index [message #162390 is a reply to message #162365] |
Fri, 10 March 2006 00:36 |
marco118
Messages: 16
Registered: March 2006
|
Junior Member |
|
|
Thanks Ross
Thanks for sharing your experience with me.
My case is, all index is stored in one index tablespace. so,
May I know can I directly use this command
Alter index <index_name> rebuild;
Anything need logging disabled?
Alter index <index_name> rebuild unrecoverable;
this is my first rebuild index job in Oracle 8 , would you let me know anything I need to concern before rebuild index?
Many Thanks
Marco118
|
|
|
|
| Re: Oracle 8 rebuild index [message #162463 is a reply to message #162390] |
Fri, 10 March 2006 06:48 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> will it increase disk space usage or less space usage?
If you use REBUILD ONLINE , yes. space utilization within the tablespace will increase.
Edit: My response may be irrelevant.
Are online rebuilds available in Oracle 8?
[Updated on: Fri, 10 March 2006 06:49] Report message to a moderator |
|
|
|
| Re: Oracle 8 rebuild index [message #162530 is a reply to message #162463] |
Fri, 10 March 2006 19:22 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
If you rebuild UNRECOVERABLE, then logging may be permanently disabled on the index, meaning you cannot do a roll-forward recovery. (I'm not sure about this, check the documentation).
If I'm right, you can ALTER INDEX afterward to switch logging back on.
_____________
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
