Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL Block Alter Index Rebuild

KRanpApr 7 2017 — edited Apr 11 2017

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.

This post has been answered by John Spencer on Apr 7 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2017
Added on Apr 7 2017
4 comments
926 views