Home | Davide Gammone

How to drop all indexes on an Oracle SQL table

: Written by: Davide Gammone; Written by: Davide Gammone; Category: Programming; Also available:; 21 April 2018; Last Updated: 10 May 2018; Hits: 22001

Long time ago I needed to delete all indexes on an Oracle SQL table. After some test I ended up with the following PL/SQL code:

Page 3 of 3

GDPR Alert

This site uses cookies, including third-party requests, to offer you services in line with your preferences. By closing this banner, scrolling this page or clicking any element, you consent to the use of cookies. If you want to learn more or opt out of all or some cookies, click on Privacy Policy...

How to drop all indexes on an Oracle SQL table