Oracle 8 rowid [message #365166] |
Fri, 16 June 2000 14:57 |
babu
Messages: 16 Registered: September 1999
|
Junior Member |
|
|
Recently we have migrated our database from oracle 7
to oracle 8. After this I am facing a problem in one
of my purge program which deletes the records based
on the rowid. What I would like to know is whether
the rowid gets changed to the new Oracle 8 format as and when we access the rows, or its changed at the time of migration? Tx in advance.
|
|
|
Re: Oracle 8 rowid [message #365168 is a reply to message #365166] |
Sat, 17 June 2000 09:12 |
Rajesh Matkar
Messages: 20 Registered: September 1999
|
Junior Member |
|
|
Hi, After mirgration in Oracle 8, you need to change your code where you are using ROWID in coding, because Oracle 8 ROWID is different from Oracle 7. you can use DBMS_ROWID built-in package for getting same rowid format.
all the best and try it.
- Rajesh
|
|
|