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
James Alexander Starritt <james_at_jamesstarritt.com> escribió en el mensaje de
noticias 97mf4k$ol023$1_at_ID-68406.news.dfncis.de...
> I have a user who appears to have dropped a key index on her database.
Now
> instead of shooting in the dark trying to find it I was wondering if there
> was a select or desc statement I can use to list all indexes ??
>
> --
>
> James Alexander Starritt (james_at_jamesstarritt.com)
>
> I am testing and developing a new search engine for Pro-Wrestling related
> sites. If you would like to get a few hits send an email along with your
> URL and Site Name to search_at_menintights.net and I will add you to the
> search.
>
>
>
Received on Fri Mar 02 2001 - 13:51:43 CST