| Oracle Compression Question [message #318332] |
Tue, 06 May 2008 08:59  |
Triton46
Messages: 3
Registered: January 2008
|
Junior Member |
|
|
OK, knowing that non-direct inserts going into a compressed table do not get compressed, what about the following scenario:
You have a table TAB_A that is made up of two partitions (LIST) based on an operational column COL_COMPR_YN. If COL_COMPR_YN = 'Y' then the data resides in partition PART_COMPR. If COL_COMP_YN = 'N' then the data reside in partition PART_NOCOMPR. PART_COMPR is a COMPRESS partition, PART_NOCOMPR is a NOCOMPRESS partition.
1)If I update a row in PART_NOCOMPR from COL_COMPR_YN = 'N' to 'Y', will the data get set to COMPRESS when moving into the partition (ROW MOVEMENT ENABLED) or would it act like a non-direct insert and leave the data as NOCOMPRESS?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
