Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to capture context from a database link?

Re: How to capture context from a database link?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Aug 2004 16:22:12 -0500
Message-ID: <ur7pxeenl.fsf@standardandpoors.com>


On 20 Aug 2004, jared_at_hwai.com wrote:
> Galen Boyer <galenboyer_at_hotpop.com> wrote in message
> news:<ullgaoq2c.fsf_at_standardandpoors.com>...
>

>> First things first.  This is wrong design.  You are putting
>> intelligence in keys.  A definitely bad thing to do.  The
>> domain needs to be an attribute on the table being inserted.

>
> No, not an intelligent key, just a way to guarantee uniqueness
> when combining sequence-generated numbers from multiple
> databases.

Well, then why didn't you ask that?

sys_guid()

-- 
Galen Boyer
Received on Mon Aug 23 2004 - 16:22:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US