CREATE TABLE personnel
(
   activity_sa_id   NUMBER NOT NULL,
   user_sa_id       NUMBER NOT NULL,
   oracle_id        VARCHAR2 (30)
)
PARTITION BY LIST (activity_sa_id)
   (PARTITION personnel1 VALUES (1),
    PARTITION personnel2 VALUES (2),
    PARTITION personnel3 VALUES (3))

CREATE UNIQUE INDEX pers_pk
   ON personnel (activity_sa_id, user_sa_id)
   LOCAL

ALTER TABLE personnel ADD (
  CONSTRAINT pers_pk
  PRIMARY KEY
  (activity_sa_id, user_sa_id)
  USING INDEX LOCAL
  ENABLE VALIDATE)

CREATE UNIQUE INDEX pers_ora_uk
   ON personnel (oracle_id, NVL2 ("ORACLE_ID", "ACTIVITY_SA_ID", NULL))