?
Solved

Oracle Modify Partition vs Move Compress

Posted on 2016-07-30
2
Medium Priority
?
102 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 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 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

777 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