Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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