> 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. > I haven't used it myself. A search on MetaLink shows that the SYS_GUID() is globally unique, as the docs state, so collisions should not happen. SYS_GUID appeared first in 8i ( not sure which version of 8i ) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------