Re: index doesn't contain duplicates

From: Nigel Thomas <>
Date: Tue, 9 Jun 2009 20:50:01 +0100
Message-ID: <>

Just for fun, I tried to duplicate this in Oracle XE and couldn't. OTOH, I only tried inserting 4 rows.

When I inserted the duplicate row, I got (as you would expect):

SQL> select uniqueness from user_indexes where index_name='TNU1'   2 /


NONUNIQUE SQL> insert into testnonunique values ('DD'); insert into testnonunique values ('DD')
ERROR at line 1:
ORA-00001: unique constraint (TESTUSER.TNU_PK) violated

(TNU_PK was created based on non-unique index TNU1)

Thinking on from Mark Powell's suggestions - how was the CTAS done?

Cheers Nigel

Received on Tue Jun 09 2009 - 14:50:01 CDT

Original text of this message