CREATE TABLE "PS_SHIFTS"
( "SHIFT_KEY" NUMBER NOT NULL ENABLE,
"EMPLOYMENT_KEY" NUMBER NOT NULL ENABLE,
"PERIOD_KEY" NUMBER NOT NULL ENABLE,
"KZAM_KEY_SHIFTS" NUMBER NOT NULL ENABLE,
"SHIFTTYPE_KEY" NUMBER NOT NULL ENABLE,
"SHIFTWORKTYPE_KEY" NUMBER NOT NULL ENABLE,
"SHIFTTRAINTYPE_KEY" NUMBER(4,0) NOT NULL ENABLE,
"PLACE_KEY" NUMBER NOT NULL ENABLE,
"DEPOT_KEY" NUMBER(4,0) NOT NULL ENABLE,
"ORGUNIT_KEY_SHIFT" NUMBER(4,0) NOT NULL ENABLE,
"DATE_KEY" NUMBER NOT NULL ENABLE,
"SOURCE_ID" VARCHAR2(50) NOT NULL ENABLE,
"SOURCESYS_ID" VARCHAR2(6) NOT NULL ENABLE,
"CODE" VARCHAR2(20) NOT NULL ENABLE,
"TIME_START" DATE NOT NULL ENABLE,
"TIME_END" DATE NOT NULL ENABLE,
"VALIDATION_DATE" DATE NOT NULL ENABLE,
"EMPLOYEE_KEY_VALIDATE" NUMBER NOT NULL ENABLE,
"GROUP_SHIFT" VARCHAR2(20),
"GROUP_CREW" VARCHAR2(20),
"TARIFF_OPERATION" NUMBER,
"TARIFF_OPERATION_REAL" NUMBER,
"TARIFF_PPV" NUMBER,
"INCLUSION" VARCHAR2(6),
"NAME" VARCHAR2(50),
"NAME_APS" VARCHAR2(50),
"RENUNCIATION_FLG" NUMBER(1,0),
"I_AUDIT" NUMBER NOT NULL ENABLE,
"I_PAID" NUMBER NOT NULL ENABLE,
"I_BATCH" NUMBER,
"U_AUDIT" NUMBER NOT NULL ENABLE,
"U_PAID" NUMBER NOT NULL ENABLE,
"U_BATCH" NUMBER,
"PLACE_KEY_FROM" NUMBER,
"PLACE_KEY_TO" NUMBER
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
PARTITION BY LIST ("PERIOD_KEY")
(PARTITION "P20000101" VALUES (20000101) SEGMENT CREATION DEFERRED
PCTFREE 1 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
)Table created.
alter table ps_shifts add partition P20160101 values(20160101) Table altered.
alter table ps_shifts add partition P20160201 values(20160201) Table altered.
alter table ps_shifts add partition P20160301 values(20160301) Table altered.
alter table ps_shifts add partition P20160401 values(20160401) Table altered.
alter table ps_shifts add partition P20160501 values(20160501) Table altered.
alter table ps_shifts add partition P20160601 values(20160601) Table altered.
alter table ps_shifts add partition P20160701 values(20160701) Table altered.
alter table ps_shifts add partition P20160801 values(20160801) Table altered.
alter table ps_shifts add partition P20160901 values(20160901) Table altered.
alter table ps_shifts add partition P20161001 values(20161001) Table altered.
alter table ps_shifts add partition P20161101 values(20161101) Table altered.
alter table ps_shifts add partition P20161201 values(20161201) Table altered.
alter table ps_shifts add partition P20180101 values(20180101) Table altered.
alter table ps_shifts add partition P20180201 values(20180201) Table altered.
alter table ps_shifts add partition P20180301 values(20180301) Table altered.
alter table ps_shifts add partition P20180401 values(20180401) Table altered.
alter table ps_shifts add partition P20180501 values(20180501) Table altered.
alter table ps_shifts add partition P20180601 values(20180601) Table altered.
alter table ps_shifts add partition P20180701 values(20180701) Table altered.
alter table ps_shifts add partition P20180801 values(20180801) Table altered.
alter table ps_shifts add partition P20180901 values(20180901) Table altered.
CREATE INDEX PK_PS_SHIFT ON ps_shifts (period_key,shift_key) local INDEXING PARTIALIndex created.
CREATE INDEX UK_PS_SHIFT ON ps_shifts (period_key,source_id, sourcesys_id) local INDEXING PARTIAL Index created.
ALTER TABLE ps_shifts ADD CONSTRAINT PK_PS_SHIFTS PRIMARY KEY (period_key,source_id, sourcesys_id) using index PK_PS_SHIFTORA-14196: Specified index cannot be used to enforce the constraint.More Details: https://docs.oracle.com/error-help/db/ora-14196
ALTER TABLE ps_shifts ADD CONSTRAINT UK_PS_SHIFT1 UNIQUE (period_key,source_id, sourcesys_id) using index UK_PS_SHIFTORA-14196: Specified index cannot be used to enforce the constraint.More Details: https://docs.oracle.com/error-help/db/ora-14196