CHECK-LIMITKEYS—Check the Index Keys
The CHECK-LIMITKEYS keyword checks whether each key that is written to an index belongs in the partition for which it is written.
The CHECK-LIMITKEYS keyword checks whether each index key belongs in the partition for which it is written. Use this keyword when you are migrating data, to verify that the source and target object have matching DDL definitions.
notvalid with RECOVER TABLESPACE and RECOVER INDEX.
This keyword has the following format:
- NODoes not check each key. This value is the default.
- YESChecks each key. Specifying YES can degrade performance.