How to drop all indexes on an Oracle table
filed in IT on Nov.11, 2009
Few days ago I needed to delete all indexes on an Oracle table. After some scripting I ended up with the following one:
BEGIN
FOR ind IN
(SELECT index_name FROM user_indexes WHERE table_name = ‘my_table’ AND index_name NOT IN
(SELECT UNIQUE index_name FROM user_constraints [...]
Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the: