oracle delete all index own by table

BEGIN
FOR ind IN
(SELECT index_name FROM user_indexes WHERE table_name = '')
LOOP
execute immediate 'DROP INDEX '||ind.index_name;
END LOOP;
END;
/
COMMIT;

原文地址:https://www.cnblogs.com/kakaisgood/p/8759940.html