Does the 'Analyze Index Valdiate Structure' lock the table for inserts,
updates and deletes in Oracle v8.1.6?
Thanks,
DF
yes it will block inserts / updates / deletes to the table .
The 'analyze index validate structure' command needs a current
structure which is not being modified as the command is running.
The only way to achieve that is to put a shared lock on the table.
Shared locks usually do prevent transaction locks and, thus, any DML
on the table.
--
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds
The 'analyze index validate structure' command needs a current
In 8.1.6, an Analyze Index Validate Structure command did indeed lock all
DML operations....
With 9i, the command has been improved and the "online" permits DML.
Cheers
Richard
True, but it does not populate index_stats :-(
--
=========================
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue"
Hi Connor,
Picky picky ;)
Richard