Hi,

What your DBA did was only generating the primary key using an index. I don't think he made a separate index with the same name. It will also show up in dba_indexes (and other dict tables).

Can you tell me if idx_seqtrand is unique?

You can only create a local primary key if the partition key is part of the PK constraint.
(Which is the case with tran_date).

Greetings

tycho