Re: duplicate index error due to datetime format

From: Karl Hewlett <fake_address_at_auckland.ac.nz>
Date: 2000/04/13
Message-ID: <8d2qk0$t88$1@scream.auckland.ac.nz>#1/1

Doh!!!

Thanks for the response

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:38F450E7.2BE3_at_yahoo.com...
> Karl Hewlett wrote:
> >
> > Hi
> >
> > I am involved in a project to move Peoplesoft data from Informix to
Oracle.
> >
> > On a number of tables I am getting a "ORA-01452: cannot CREATE UNIQUE
INDEX;
> > duplicate keys found" which appears to be because of datetime data that
> > Informix will index because it goes to milli-second detail but Oracle is
> > only going to seconds.

>
> sorry - dates do not contain anything below seconds in Oracle. A
> solution would be a surrogate key (populated by a sequence) to give a
> unique key with a non-unique index on the date column.
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Thu Apr 13 2000 - 00:00:00 CDT