Tuesday, May 28, 2013

Dynamical sql to drop all disks from an ASM disk group

set pagesize 0

select 'ALTER DISKGROUP '||  dg.name || ' DROP DISK '|| d.name || ';' 
from v$asm_disk d join v$asm_diskgroup dg
on (d.group_number = dg.group_number)
where dg.name = '&diskgroup_name';

No comments:

Post a Comment