sql>set head off
sql>set pages 5000
sql>spool drop_index.sql
sql>select 'drop index '||owner||'.'||index_name||';' from dba_indexes where tablespace_name='USERS';
sql>spool off;
sql>exit;
sql>set head off
sql>set pages 5000
sql>spool drop_index.sql
sql>select 'drop index '||owner||'.'||index_name||';' from dba_indexes where tablespace_name='USERS';
sql>spool off;
sql>exit;