Oracle Modify Partition vs Move Compress

Dear Experts,

Could you please explain me what the difference is between:

alter table <table name> modify partition compress
and
alter table <table name> move partition compress ?

Best regards
GurcanKAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
when used with no other options, as you have shown, the two should be identical in functionality.

the reason the two statements exist is that each "can" do other things.

for example:
"modify" can change the inmemory or logging settings
"move" is used to move a partition to a new tablespace.

if you don't do anything other than compress, then either statement will do the same thing.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
no points for me:
both will invalidate global indexes ( unless you also specify to rebuild them), and require the space for the uncompressed and the compressed blocks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.