Skip to Main Content

Oracle Database Discussions

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!

ERROR WHEN ALTERING TABLE FOR SHRINK

3267386Jan 11 2017 — edited Jan 11 2017

I have problem with index extent

and I'm trying to free space on the index table

by doing this

alter table hr.pay_run_result_values enable row movement;

alter table hr.pay_run_result_values shrink space;

and when executing this alter table hr.pay_run_result_values shrink space;

I'm getting this :

Erreur commençant à la ligne 9 de la commande :

alter table hr.pay_run_result_values shrink space

Rapport d'erreur :

Erreur SQL : ORA-01735: option ALTER TABLE non valide

01735. 00000 -  "invalid ALTER TABLE option"

*Cause:   

*Action:

Can you help

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2017
Added on Jan 11 2017
4 comments
988 views