Re: Does 'Analyze Index <IndexName> Validate Structure' Lock for DML Operations?

On Thu, 22 May 2003 17:57:02 -0700, SAP BASIS Consultant wrote:

> Hello,
>
> Does the 'Analyze Index Valdiate Structure' lock the table for inserts,
> updates and deletes in Oracle v8.1.6?

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