Solved

Oracle Modify Partition vs Move Compress

Posted on 2016-07-30
2
77 Views
Last Modified: 2016-07-31
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
Comment
Question by:GurcanK
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 total points
ID: 41735903
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
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 41735908
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question