Pctfree [message #424784] |
Tue, 06 October 2009 00:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abdulahads
Messages: 44 Registered: October 2009 Location: SAUDI
|
Member |
![i_am_aahad](/forum/theme/orafaq/images/yahoo.png)
|
|
Pctfree is set to 10 ,
Block in filled with insert rows.
Free space is 10,
While updating table if free space is filled
what will happen next ?
|
|
|
|
|
Re: Pctfree [message #424813 is a reply to message #424784] |
Tue, 06 October 2009 02:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balakrishnay
Messages: 54 Registered: September 2009 Location: Pune
|
Member |
|
|
Hi,
Then there is someting called row migrating & row chaining .. please go through the concepts properly.
Regards
Bala
|
|
|
|
Re: Pctfree [message #424821 is a reply to message #424812] |
Tue, 06 October 2009 02:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
abdulahads wrote on Tue, 06 October 2009 09:05as it is said that only free space is 10 if data is filled while update and this 10 is also finish and new update need some more space so what next? I think so it's clear now
In this case, the updated row is moved into another block but its header is kept in the original block, and this row is named a migrated row.
Regards
Michel
|
|
|