RE:How can I get a list of all indexes in SQL Plus?

From: Juan Miranda <jmiranda_at_mundo-r.net>
Date: Fri, 2 Mar 2001 20:04:08 -0000
Message-ID: <97oqlq$4c12@cesio.mundo-r.com>

SET HEADING OFF
SET FEEDBACK OFF
SET LINESIZE 200
SET PAGESIZE 0
SPOOL C:\temp.sql
SELECT 'SELECT to_char(SYSDATE,''YYYY/MM/DD HH24:MI:SS'') FROM dual;' FROM dual;
SELECT 'ALTER INDEX '||owner||'.'||index_name||' REBUILD TABLESPACE '||tablespace_name||';'

        FROM dba_indexes
        WHERE owner NOT IN ('SYS','SYSTEM')
        AND tablespace_name IS NOT NULL
        ORDER BY owner, index_name;

SELECT 'SELECT to_char(SYSDATE,''YYYY/MM/DD HH24:MI:SS'') FROM dual;' FROM dual;
SPOOL OFF
SET ECHO ON
SET FEEDBACK ON Received on Fri Mar 02 2001 - 14:04:08 CST