• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

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
0
GurcanK
Asked:
GurcanK
2 Solutions
 
sdstuberCommented:
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]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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now