Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table lock while creating index?

754491Jul 3 2010 — edited May 22 2013
Hello,

my db is oracle10g. My database is OLTP system. I wanted to create index on one of the table. The table has 200 million records.

Does it lock the entire table when i create index? I am thinking, how it impacts the regular operations in the database while creating the index?

Any help is appreciated...
This post has been answered by mbobak on Jul 3 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2013
Added on Jul 3 2010
#general-database-discussions
5 comments
18,727 views