Rowid in Oracle 8i

[hlp4aloracle]

Dear Friends,

I m new to this form, if i did anything wrong please forgive me.

Recently i faced a problem regarding Rowid values in Oracle 8i. I want some more information regarding Rowids.
My queries are
1) Is it possible to change the Rowid values in the datebase.(by using queries like that)
2) Is there any way automatic Jump of rowids in database.

Actually rowid values increment by 1 .but recently rowid value is jumped to another value (Unexpected value) automatically in my database, I want to know how it is possible?

Thanks in advance..

Regards,
hlp4al

[giteshtrivedi]

Hi,

Rowid physically stored for each row in database. You cann't change it. If you want to change such rowid then you should need to delete and insert row again. Second thing you cann't insert your own rowid in table.