create index PK_UPPER_ID_CARED_NO on OFFENDER (upper(id_card_no))
tablespace BACKGROUND_INFO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
tablespace BACKGROUND_INFO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);