what is row chaining and row migration?

Answers were Sorted based on User's Feedback



what is row chaining and row migration?..

Answer / 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

what is row chaining and row migration?..

Answer / nitun

Row Chaining happens when a row is too large to fit into a
single database block. For example, if you use a 8KB block
size for your database and you need to insert a row of 16KB
into it, Oracle will use 2/3 blocks and store the row in
chain of data blocks for that segment. And Row Chaining
happens only when the row is being inserted

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Certifications Interview Questions

I am planing for sql exam so please help me about exam questions.

1 Answers  


What is the exam fees for oca,ocp,ocm certification course in Bangalore?

1 Answers   Oracle,


Which is the good institution for ORACLE certification in delhi?

11 Answers  


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?

0 Answers  


i have 6 years of gap after doing bca. how to get a good job now.

0 Answers   IBM,






is any oracle education partner in Bangalore?

5 Answers  


Can you please send me the dups for the OCA certification?

2 Answers   IBM,


where the bestone of the oracle certification tutorials in the hyderabad plz give me full contact address to my ramu.nani28@gmail.com thank you frnds

1 Answers   Oracle,


hi i'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..

3 Answers  


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

0 Answers   Wipro,


sir plse tell me oracle 10g ocp certification material and previous papers send to me

1 Answers  


Hi guys, I want to clear exams of OCA and informatica developer (three papers).......Could you all plz help me and send me the dumps for the same...Thanks in advance!!!!

0 Answers  


Categories
  • Cisco Certifications Interview Questions Cisco Certifications (2321)
  • Microsoft Certifications Interview Questions Microsoft Certifications (171)
  • Sun Certifications Interview Questions Sun Certifications (45)
  • CISA Certification Interview Questions CISA Certification (744)
  • Oracle Certifications Interview Questions Oracle Certifications (64)
  • ISTQB Certification Interview Questions ISTQB Certification (109)
  • Certifications AllOther Interview Questions Certifications AllOther (295)