-
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:
:= . ( @ % ;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|