How to run DDL on busy objects ?
Sometimes we always get resource too busy when DDL on a object. Here is how to use PL/SQL to do that.
declare resource_busy exception; pragma exception_init (resource_busy,-54); begin loop begin execute immediate 'alter index INDEX_NAME noparallel'; exit; exception when resource_busy then dbms_lock.sleep(1); end; end loop; end; /
Comments
Post a Comment