Home » RDBMS Server » Server Administration » Oracle 8 rowid
- Oracle 8 rowid [message #365166] Fri, 16 June 2000 14:57 Go to next message
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.

Report message to a moderator

- 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

Report message to a moderator

Previous Topic: Oracle DBA
Next Topic: Re: Statspack
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 04 14:10:06 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.