| Pctfree [message #424784] |
Tue, 06 October 2009 00:38  |
abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI
|
Member |
|
|
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  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
