반품
-
제목
When processing tables that do not have a unique key, Oracle reuses ROWIDs for rows deleted durin -
설명
A problem was recently discovered in Space Manager with LiveReorg 6.0 when processing tables that do not have a unique key. If Oracle reuses ROWIDs for rows deleted during the live reorg, duplicates may occur in the reorganized table. (This issue does not apply to Space Manager with LiveReorg version 5.7 or earlier) -
원인
The problem may occur under the following conditions;- Table does not have a unique key
- Table activity during the reorg includes row updates, followed by deletes to the same rows, followed by inserts
- Oracle reuses ROWIDs on the inserts (depends upon storage attributes­)
This implies that a relatively large amount of update/delete/insert activity occurred during the reorg in order to cause this flaw to occur. -
해결 방안
Upgrade to Space Manager with LiveReorg version 6.2 along with the QSA agent onSupportlink