Re: 1 row = 1 extent

Youtz wrote:
>
> Hello,
> I want to insert some rows in a table that manage users and their rights
> (internet application) and have one extent for each row. Is there a way to
> be sure to get one extent for each row ?
> I thought it might solve some locks problems I get on the users.
> Best regards,
> Youtz.

Maybe you mean 1 block to avoid contention ? You won't get any locking problems unless people are trying for the same row. If its block contention you are worried, increase the pctfree

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."