Rebuild indexes

[pascal01]

Hi I want to move my indexes to another tablespace. (Rebuild)
I am trying to create the script but keep getting script errors.
Could someone please see what wrong with this script ?

select 'alter INDEX | 'INDEX_NAME'' | 'tablespace name' 'INDX' from all_indexes where owner = 'DEV';

[monto1]

select 'alter index '||index_name||' rebuild tablespace tablespace_name;' from dba_indexes where owner='XYZ'

Regards

[gtcol]

Try this:
SELECT 'alter index ' ||index_name||' rebuild tablespace '|| tablespace_name||' from all_indexes where owner= DEV'
all_sqls from dba_indexes WHERE OWNER='DEV';

HTH,
gtcol

[PAVB]

Nice... but you have to test your code before posting it guys

Code below would take care of your non-partitioned indexes..

select  'alter index '                      || 
        owner                               ||
        '.'                                 ||
        index_name                          || 
        ' rebuild tablespace '              || 
        'YOUR_NEW_TABLESPACE;' "REBUILD INDEX COMMAND"           
from    dba_indexes 
where   OWNER='DEV'
and     tablespace_name is not Null;

If needed you may have to alter the code to rebuild ONLINE if you are planning to do it while having your database available to users.