0

I have Oracle Release 12.1.0.2.0 and I need to reclaim wasted space due to data fragmentation. I have been told that I should use the instruction "MOVE ONLINE".

I tried the following but I'm getting errors:

ALTER TABLE table MOVE ONLINE UPDATE INDEXES 
ORA-14133 "ALTER TABLE MOVE cannot be combined with other operations"

and:

ALTER TABLE BFD_PRATICA MOVE ONLINE
ORA-01735 "invalid ALTER TABLE option"

My tables are all non partitioned and non index-organized. I need to perform this operation with no down time.

What am I missing?

2

Online table move is a 12.2 feature.

Online Table Move

About Moving a Table to a New Segment or Tablespace

You can use DBMS_REDEFINITION or SHRINK.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.