Prev: OracleStartORCL(STRTDB73.EXE) error at Windows XP / Windows 2003
Next: Error messages not displayed
From: david.rydzewski on 17 Jun 2005 13:40
How about something like this....

(didn't compile or test this btw.)


declare
resource_locked exception;
pragma exception_init(resource_locked, -54);
retry number := 0;
begin

loop

begin

execute immediate 'alter index x validate structure';
return;

exception when resource_locked then

if retry > 999 then
raise_application_error( -20001, 'Could not aquire lock after
'||retry||' tries.' );
end if;

retry := retry + 1;
dbms_lock.sleep ( 0.01 );

end;

end loop;

end;
/

From: AK on 17 Jun 2005 14:06
have you tried ONLINE clause of ANALYZE?

First  |  Prev  | 
Pages: 1 2
Prev: OracleStartORCL(STRTDB73.EXE) error at Windows XP / Windows 2003
Next: Error messages not displayed