Re: Deleting & inserting problem

manish.nevrekar_at_gmail.com wrote:

> The only way to order data is to have an order by clause. The data you
> add after deleting will not be inserted in the same spot. Oracle has a
> whole list of things that it does to take care of space management.

Except with 10g if you use sorted hash clusters. Might also be true with IOT's but I am rushing out the door.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)