Partition at AUDIT_DETAILS
Want to have partitional at unique AUDIT_DETAILS. If we add ci_partition_date to unique index AD_PK on AUDIT_DETAILS (CIKEY, DETAIL_ID) will it be ok? May be we can remove AD_PK_INT primary key (CIKEY, DETAIL_ID) and change unique index AD_PK to normal?
Table:
-- Create table
create table AUDIT_DETAILS
(
cikey INTEGER not null,
detail_id INTEGER not null,
bin_csize INTEGER,
bin_usize INTEGER,
doc_ref VARCHAR2(300),
bin BLOB,
ci_partition_date TIMESTAMP(6) not null
)
tablespace DATA_TS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 512K
next 512K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints