titanium0203
asked on
How to create a Oracle Index without locking the column.
Hi ,
How can I create Oracle index without locking the column?
Currently total rows on the targeted table is 50 million of rows and data being updated
every hour.
regards,
titanium0203
How can I create Oracle index without locking the column?
Currently total rows on the targeted table is 50 million of rows and data being updated
every hour.
regards,
titanium0203
This is what I was thinking about in 11g it's far safer: http://richardfoote.wordpress.com/2008/02/11/index-create-and-rebuild-locking-improvements-in-11g-ch-ch-ch-changes/
ASKER
Hi MrNed,
FYI, Our Oracle is in 10G.
FYI, Our Oracle is in 10G.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/indexes003.htm#insertedID6
CREATE INDEX emp_name ON emp (mgr, emp1, emp2, emp3) ONLINE;