Home » RDBMS Server » Server Administration » Oracle 8 rowid
Oracle 8 rowid [message #365166] Fri, 16 June 2000 14:57 Go to next message
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 Go to previous message
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
Previous Topic: Oracle DBA
Next Topic: Re: Statspack
Goto Forum:

Current Time: Sun May 26 11:00:46 CDT 2024