Executing the the below command in pl/sql block job I see the following error:
alter index Schema_Name.Index_Table rebuild nologging;
Error:
"ORA-06550: line 1, column 750:
PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:
( begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
"
Can you suggest the right syntax to rebuild index using oracle job pl/sql block.
Thanks.