-
Rowid in Oracle 8i
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
-
Re: Rowid in Oracle 8i
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.
-
Re: Rowid in Oracle 8i
As far as I know, there is no rowid in MySQL. If you like you can
ALTER the table and insert a unique auto-increment field to the table.
