Rebuild indexes
I need to move 1500 indexes to another tablespace. Instead of creating a script to rebuild the indexes, is there a DBS command that I can run? Please let me

-------------------------------------------------------------

Hi,
you can do it by writing a PL/SQL code that uses dynamic SQL.

i.e,

DECLARE
CURSOR cur_name IS
(LIST OF all the index from dba_indexes);
BEGIN
open the cursor for dynamic sql.
FOR vname IN cur_name LOOP
you can use dynamic sql here.
END LOOP;
close the opened cursor.
END;
/

Thanks..
Bhavin