| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SYS_GUID
The old values would certainly be present in a recovered database.
Depending on the type of recovery, new values might look slightly different
than old values, but that internal difference should be immaterial unless
you are trying to assign more value that "a globally unique identifier" to
the result of SYS_GUID. If you were to abuse the SYS_GUID, for example, to
try to extract which machine or database actually created the record, you
might have trouble down the line, but you shouldn't be doing that in the
first place.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Michael Fontana
Sent: Tuesday, August 10, 2004 2:31 PM
To: oracle-l_at_freelists.org
Subject: SYS_GUID
Does anyone use the SYS_GUID function made available in Oracle9i?
I recommended this be used instead of sequences for a distributed processing design, and some on the team are rightfully concerned about recoverability issues. For example, would a recovered database table have the original sys_guid values? Would the recovered values still be unique? If anyone knows the answers to these questions, or has some experience with using this functionality, I would appreciate hearing about their experience.
Thanks!
Michael Fontana
Sr. DBA
NTT/Verio
 |
 |