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;

posted @ 2018-04-09 15:05  kakaisgood  阅读(219)  评论(0编辑  收藏  举报