RE: index rebuild - locking
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "dd.yakkali@xxxxxxxxx" <dd.yakkali@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Jul 2010 07:43:08 +0200
But the real question is, why do you want to rebuild the index?
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of dd yakkali
Sent: vrijdag 9 juli 2010 4:50
To: oracle-l@xxxxxxxxxxxxx
Subject: index rebuild - locking
i have a big table ( 10 GB ) which has an index on a number field. Index is
almost same size as the table and I want to rebuild the index
the database is very active and the table is also very active read about 100K
times in 20 minutes and few writes as well. I want to know during the index
rebuild process, does oracle allow writing to the table ( insert into that
table) ?
Please let me know, i am kind of lazy to do test.
Thanks
Deen
--
http://www.freelists.org/webpage/oracle-l
Other related posts: