Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 TorvaldsReceived on Sun May 25 2003 - 04:23:27 CDT