Re: Deleting & inserting problem

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Tue, 01 Feb 2005 12:32:50 +0100
Message-ID: <ctnslp$ftt$1$830fa7a5@news.demon.co.uk>

Guru wrote:
> Hi All
>
> I have a scenario like this... Suppose
>
>
> Table A Contains
>
> colA
> ------
> AA
> BB
>
>
> suppose i delete the record AA.. and inserting record CC its
> displaying like this
>
> Table A Contains
>
> colA
> ------
> BB
> CC
>
>
> Actually i want like this
>
> Table A Contains
>
> colA
> ------
> CC
> BB
>
> I want to insert the record in the deleted col.I know we can update
> it.. But the scenario is like this..
> Warm Regards
> Guru
>

Afternoon Guru,

I'm afraid that Oracle will put the new row into wherever it sees fit, you cannot control this (much).

Oracle has things like freelists, freelist groups, PCTFREE and PCTUSED settings to control how much space is used in a block for data, 'expansion' room for existing data and so on.

It is possible that you may get the 'CC' row inserted into the same block as the deleted 'AA' row, but there are no guarantees.

If you want the rows retrieved by a SELECT in some sort of order, then you must specify the order and have some data in each row that you can order by.

Cheers,
Norm. Received on Tue Feb 01 2005 - 05:32:50 CST