what is row chaining and row migration?

Answer Posted / daman

We will migrate a row when an update to that row would cause
it to not fit on the block anymore (with all of the other
data that exists there currently). A migration means that
the entire row will move and we just leave behind the
«forwarding address». So, the original block just has the
rowid of the new block and the entire row is moved.
Row chaining nstead of just having a forwarding address on
one block and the data on another we have data on two or
more blocks.

Is This Answer Correct ?    16 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain procedure of the OCJP cerification, and exam fee please explain

3708


hello friends. i m saravanan. my stream (B.Tech)Information Technology. i m seeking for job. now i plan to do informatica certification.. but this certification is only for experienced software professional. i m having no software experience. do u think is informatica certification is useful to my carrer..?? and pls explain which certification is better Oracle (Or) Informatica????? my mail id is ysaravananbtech@gmail.com mobile no is>> +91-9894060089

2052


hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

1727


I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .

1431


im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions

2163






Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

2133


I have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...

2340


Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)

4624


Hi, I am doing mba hr and having 4.4 yrs experience in marketing research and accounts payable together. Now i have 2 yrs of carrier break. Will it be advisable to do oracle hrms certification and grab new opportunities?

1930


Hi. I wish to appear for OCA exam. Can anyone pls guide me on the syllabus n fee structure of the exam. I know that there are 2 tracks : developer and dba. What is the difference between the two? All suggestions are welcome. Thanks.

2389


i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

2170


being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me

1713


I completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.

2246


How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.

2252


what is the exact syllabus for oracle certification level 1?

3676