That did not work. It did not like that statement. Here is what I have below:

Declare
V_sql_1 varchar2(100);
V_sql_2 varchar2(100);
v_sql_3 varchar2(100);
Cursor Ind_Cur is Select index_name from all_Indexes where TABLESPACE_NAME = 'PRO_DATA' and owner in ('PRO','OHT') Order by INDEX_NAME;

Begin

For Ind_rec in Ind_Cur Loop

v_sql_1 := 'Alter index PRO.';

v_sql_2 := ind_rec.index_name;

v_sql_3 := ' rebuild tablespace pro_index';

v_sql_1 := v_sql_1||v_sql_2||v_sql_3;

execute immediate v_sql_1;

dbms_output.put_line(v_sql_1||' has been moved to PRO_INDEX');

End loop;

End;

ERROR: execute immediate v_sql_1;
*
ORA-06550: line 19, column 9:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following:

:= . ( @ % ;