Re: Newbie Q

you can use this kind of code (modify the rebuild and where close as you need it) :

spool c:\temp\rebind.sql
SELECT 'ALTER INDEX ' || OWNER || '.' || INDEX_NAME || ' REBUILD TABLESPACE STRTS_INDEX;'
 FROM all_indexes
  WHERE tablespace_name = 'STRTS_INDEX'; spool off;
START c:\temp\rebind.sql

• youtz.

"Eduard de Vries" <edevries_at_footlocker.com> wrote in message news:u194ughcoogca6_at_corp.supernews.com...
> Hi,
>
> I have 1 instance of Oracle which contains about 75 tables and about 150
> indexes.
> Is there a way to rebuild the indexes without entering the command alter
> index "indexname" rebuild for every single index?
>
> Thanks in advance,
>
> Eduard de Vries
> edevries_at_footlocker.com
>
>
Received on Mon Dec 10 2001 - 08:49:58 CST