no, the idx_seqtrand is non-unique, that's what i'm wondering. he's enforcing a non-unique key on that table, where in u can enforce a unique key on that table, right???

so what's the use of creating another constraint (PK)???

isnt' that an additional overhead to oracle.