Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Inserts and row chaining
"Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> wrote:
> The rows can be inserted into the data blocks provided that they are in the freelist.
>The block can put in the freelist provided that the space usage fell below PCTUSED. As a
>result, the rows cannot be inserted even though the space usage does not reach PCTFREE.
>
I think the question is something like this...
If a block is already on the freelist (i.e. it fell below pctused but hasn't reached pctfree yet), and there's only 50 bytes remaining until it hits pctfree, and you have a 100 byte row, can it be inserted into that block?
Please corrent me if I'm wrong but I think the answer is no. Only an update can cause a chaned row.
-- Chuck Hamilton chuckh_at_dvol.com This message delivered by electronic sled dogs. WOOF!Received on Tue Jan 21 1997 - 00:00:00 CST