what is row chaining and row migration?
Answers were Sorted based on User's Feedback
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 |
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 |
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
Which one is the best institute in Noida or in Delhi NCR from where i can pursue Oracle HRMS course. Pls. provide me the details
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 ..
hai, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.
Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;
what is row chaining and row migration?
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
i wrote my oca and ocp exam last year novemeber i got my oca certificate but havnt gotten my ocp i completed my hands-on and an email was sent to me saying my ocp will be delivered in 30days its 4months now and i have not seen my certificate.i will loose my job next month cos of that pls help me
2 Answers Cognizant, Infogain, Infosys, Ora Tech,
hai what are the certification courses available in oralcle certification
hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.