We use sys_guid for all primary keys in our application. We frequently
move schemas between machines with no ill effects. Although the
decision to use sys_guid was made before I took my current job, and I
wasn't convinced that sequences wouldn't have done the job just as
well, when we started using multi-master replication I was very happy,
because managing sequences in replicated databases is a pain. With
sys_guid, there's no sweat.
- Michael Fontana <mfontana_at_verio.net> wrote:
> 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
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 10 2004 - 16:15:26 CDT
