<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Could you please explain me what the difference is between:<br />
<br />
alter table &lt;table name&gt; modify partition compress<br />
and <br />
alter table &lt;table name&gt; move partition compress ?<br />
<br />
Best regards
</div>
</div>


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

Oracle Modify Partition vs Move Compress

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.