Re: ROWID Query

There is no way to insure that rowids are sequential within a table.

Using Oracle's Enterprise's Tablespace Manager can show you just how fragmented (non-sequential) a table's storage blocks can be.

<mark.ragan_at_dial.pipex.com> wrote in message news:39de51c1.1978875_at_news.dial.pipex.com...
> Can anyone clarify the allocation & usage of ROWID's;
>
> I have a program which runs frequently and creates in excess of
> 100,000 records, which I may wish to delete later. There is no unique
> way of identifying these records, and the table is extremely large so
> creating an identifying column would take up a lot of wasted space. I
> know that there are lots of ways of achieving whay I want but would
> the following idea work???
>
> If I know the ROWID of the FIRST record created, and the ROWID of the
> last ROWID created, am I safe to use the following delete command, or
> do I risk ROWID's being reused if some of these records have already
> been deleted?
>
> delete from XXXX where ROWID >= FIRST and ROWID <= LAST;
>
> TIA
>
> Mark
>
Received on Fri Oct 06 2000 - 19:25:34 CDT