Oracle SOA Suite (MOSC)

MOSC Banner

Partition at AUDIT_DETAILS

edited Sep 11, 2019 4:53AM in Oracle SOA Suite (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center