HELP - how can you get duplicate rows with unique index
emersoklDec 12 2008 — edited Dec 12 2008I hope someone can help me!
I have duplicate rows in a table with a unique index. I am running Oracle 11g windows database. The index descripttion is below. How can this happen? Is there some way to validate indexes are working?
Thanks!
Kathie
CREATE UNIQUE INDEX SYSADM.PS_ADDRESSES_SA ON SYSADM.PS_ADDRESSES_SA
(EMPLID, ADDRESS_TYPE, "EFFDT" DESC)
LOGGING
TABLESPACE PSINDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 40K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;