| Difference between Partition Compress [message #482318] |
Thu, 11 November 2010 01:10  |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
Hi,
I am using compress partition for a large table.During the process I have used the below command for compress---
1. ALTER TABLE <TABLE_NAME> MODIFY PARTITION P1 COMPRESS;
However I found there are different command as below:-
2. ALTER TABLE <TABLE_NAME> MOVE PARTITION P1 COMPRESS;
What is the basic difference between these two as the compression is happening for both command.
Regrads-
P
|
|
|
|
|
|
| Re: Difference between Partition Compress [message #482337 is a reply to message #482327] |
Thu, 11 November 2010 01:48  |
pokhraj_d
Messages: 117
Registered: December 2007
|
Senior Member |
|
|
I have 10,000 rows at P1 partition.
If I use ---
ALTER TABLE <TABLE_NAME> MODIFY PARTITION P1 COMPRESS; it will compress data from 10001 th rows.The previous 10000 th rows will be un-compressed.
And if I use the second one----
ALTER TABLE <TABLE_NAME> MOVE PARTITION P1 COMPRESS; it will compress 10000 th rows as well as the current data.
Am I currect?
Thanks-
P
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
