rem
rem Will drop all indexes for the executing owned by the executing
rem user
rem
rem  Created by Ed Campbell on 7/31/02
rem
rem 
set linesize 132
set pagesize 0
set heading off
set verify off
set echo off
set feedback off
set termout off
spool drop_indexxx.sql
prompt spool drop_indexx.lis

SELECT ' DROP INDEX '|| index_name ||';'
  FROM user_indexes
  WHERE table_owner = 'DESIGN2';

prompt spool off
spool off
@drop_indexxx.sql
prompt Check drop_indexe.lis log file for any errors