Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GUID Fields in Oracle
Thanks so much for the help!!!
"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message
news:3B2FD3EE.E9477C02_at_attws.com...
> rbc wrote:
>
> > are RAW replicable? I know LONGRAW isn't but I'm not sure about RAW
> >
> > "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > news:3B2EE1BD.4721F7AA_at_exesolutions.com...
> > > Jim Kennedy wrote:
> > >
> > > > Just store it in a varchar2 field.
> > > > Jim
> > > > "rbc" <astrobran_at_yahoo.com> wrote in message
> > > > news:JIpX6.75349$r4.828733_at_e420r-atl3.usenetserver.com...
> > > > > In SQL Server, there is a GUID datatype that we use in our
replication.
> > > > > However, we need to determine the feasibility of Oracle as a back
end
for
> > > > > some customers. In this case, we need to be able to store the
GUIDs as
we
> > > > > currently do and also allow those fields to be used in
replication.
> > > > > Is this possible in Oracle and, if so, what datatype would be used
since I
> > > > > haven't seen mention of a GUID datatype in Oracle.
> > > > >
> > > > > FYI, using Oracle 8i (8.1.7)
> > > > >
> > > > > Thanks,
> > > > > Brandon
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > > GUIDs in Oracle are meant to be stored in a field of type RAW(16).
> > >
> > > Daniel A. Morgan
> > >
> > >
>
> LONGs and LONG RAW are obsolete. RAW is not and should replicate without a
> problem.
>
> Daniel A. Morgan
>
>
Received on Tue Jun 19 2001 - 17:48:17 CDT