Home » SQL & PL/SQL » SQL & PL/SQL » is rowid assinged incrementaly ?
is rowid assinged incrementaly ? [message #6907] Sun, 11 May 2003 01:20 Go to next message
Shahanur Rahman
Messages: 27
Registered: April 2003
Junior Member
Hi

Can anybody plz tell me :

Does oracle assign the rowid incrementaly ?
I mean does the newly inserted row get the next number(rowid) of the previously inserted row?

Thanks.
[message #6912 is a reply to message #6907] Sun, 11 May 2003 04:01 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Nope,
ROWID is being assigned by Oracle as a reference to the physical location and cannot be used to identify the latest records inserted, to sort data,... . Look also here. It provides the quickest access to a given record.

MHE
Re: is rowid assinged incrementaly ? [message #6922 is a reply to message #6907] Sun, 11 May 2003 23:55 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
It seems my reply has been eaten partly by the board, so here we go again:

Is ROWID assigned incrementaly? No, Oracle assigns a ROWID to identify the PHYSICAL location of a row of data. There's no guarantee whatsoever whether a row is being stored right next to the previously inserted rows of a table. ROWID provides the quickest access to any given row. See also here for more info.

(I hope this message gets through...)
HTH,
MHE
Re: is rowid assinged incrementaly ? [message #6926 is a reply to message #6922] Mon, 12 May 2003 01:02 Go to previous message
Shahanur Rahman
Messages: 27
Registered: April 2003
Junior Member
Thanks for your help.
Previous Topic: ORACLE9i
Next Topic: change a table from one schema to another
Goto Forum:
  


Current Time: Thu Mar 28 18:59:44 CDT 2024