What is row chaining?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is row chaining?
Rating:
Row chaining occurs when a new row cannot fit in a single data block initially. In such cases, the data pertaining to the row is stored over several blocks reserved for the corresponding segment. Row chaining always occurs for rows containing the LONG or LONG RAW datatype. This is because data pertaining to such datatypes is generally large and cannot be adjusted in a single data block.
Rating:
Was this information helpful?
Other articles
- What is a cluster ?
- What is DBMS_SYSTEM package?
- What is checkpoint process (CKPT)?
- What are exclusive locks ?
- What are materialized views?