-- Create table
create table PC_LINK_ATTACHMENT
(
  PXCREATEDATETIME       DATE,
  PXCREATEOPNAME         VARCHAR2(256 CHAR),
  PXCREATEOPERATOR       VARCHAR2(256 CHAR),
  PXCREATESYSTEMID       VARCHAR2(64 CHAR),
  PXINSNAME              VARCHAR2(256 CHAR),
  PXLINKEDCLASSFROM      VARCHAR2(510 CHAR),
  PXLINKEDCLASSTO        VARCHAR2(510 CHAR),
  PXLINKEDREFFROM        VARCHAR2(510 CHAR),
  PXLINKEDREFTO          VARCHAR2(510 CHAR),
  PXOBJCLASS             VARCHAR2(192 CHAR),
  PXUPDATEDATETIME       DATE,
  PXUPDATEOPNAME         VARCHAR2(256 CHAR),
  PXUPDATEOPERATOR       VARCHAR2(256 CHAR),
  PXUPDATESYSTEMID       VARCHAR2(64 CHAR),
  PYLABEL                VARCHAR2(128 CHAR),
  PZINSKEY               VARCHAR2(510 CHAR) not null,
  PZPVSTREAM             BLOB,
  SICORRATTACHMENTSTATUS VARCHAR2(510 CHAR),
  PYMEMO                 VARCHAR2(255),
  PYCATEGORY             VARCHAR2(30),
  PYFILEORCATEGORY       VARCHAR2(30 CHAR)
)
partition by range (PXCREATEDATETIME)
(
  partition P20101101_20101130 values less than (TO_DATE(' 2010-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20101201_20101231 values less than (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110101_20110131 values less than (TO_DATE(' 2011-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110201_20110229 values less than (TO_DATE(' 2011-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110301_20110331 values less than (TO_DATE(' 2011-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110401_20110430 values less than (TO_DATE(' 2011-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110501_20110531 values less than (TO_DATE(' 2011-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110601_20110630 values less than (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110701_20110731 values less than (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110801_20110831 values less than (TO_DATE(' 2011-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20110901_20110930 values less than (TO_DATE(' 2011-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20111001_20111031 values less than (TO_DATE(' 2011-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20111101_20111130 values less than (TO_DATE(' 2011-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20111201_20111231 values less than (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120101_20120131 values less than (TO_DATE(' 2012-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120201_20120229 values less than (TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120301_20120331 values less than (TO_DATE(' 2012-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120401_20120430 values less than (TO_DATE(' 2012-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120501_20120531 values less than (TO_DATE(' 2012-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120601_20120630 values less than (TO_DATE(' 2012-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120701_20120731 values less than (TO_DATE(' 2012-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120801_20120831 values less than (TO_DATE(' 2012-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20120901_20120930 values less than (TO_DATE(' 2012-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20121001_20121031 values less than (TO_DATE(' 2012-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20121101_20121130 values less than (TO_DATE(' 2012-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20121201_20121231 values less than (TO_DATE(' 2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130101_20130131 values less than (TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130201_20130228 values less than (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130301_20130331 values less than (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130401_20130430 values less than (TO_DATE(' 2013-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130501_20130531 values less than (TO_DATE(' 2013-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130601_20130630 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130701_20130731 values less than (TO_DATE(' 2013-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130801_20130831 values less than (TO_DATE(' 2013-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20130901_20130930 values less than (TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20131001_20131031 values less than (TO_DATE(' 2013-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20131101_20131130 values less than (TO_DATE(' 2013-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20131201_20131231 values less than (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140101_20140131 values less than (TO_DATE(' 2014-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140201_20140228 values less than (TO_DATE(' 2014-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140301_20140331 values less than (TO_DATE(' 2014-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140401_20140430 values less than (TO_DATE(' 2014-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140501_20140531 values less than (TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140601_20140630 values less than (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140701_20140731 values less than (TO_DATE(' 2014-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140801_20140831 values less than (TO_DATE(' 2014-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20140901_20140930 values less than (TO_DATE(' 2014-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20141001_20141031 values less than (TO_DATE(' 2014-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20141101_20141130 values less than (TO_DATE(' 2014-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20141201_20141231 values less than (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150101_20150131 values less than (TO_DATE(' 2015-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150201_20150228 values less than (TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150301_20150331 values less than (TO_DATE(' 2015-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150401_20150430 values less than (TO_DATE(' 2015-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150501_20150531 values less than (TO_DATE(' 2015-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150601_20150630 values less than (TO_DATE(' 2015-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150701_20150731 values less than (TO_DATE(' 2015-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150801_20150831 values less than (TO_DATE(' 2015-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20150901_20150930 values less than (TO_DATE(' 2015-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20151001_20151031 values less than (TO_DATE(' 2015-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20151101_20151130 values less than (TO_DATE(' 2015-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20151201_20151231 values less than (TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160101_20160131 values less than (TO_DATE(' 2016-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160201_20160229 values less than (TO_DATE(' 2016-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160301_20160331 values less than (TO_DATE(' 2016-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160401_20160430 values less than (TO_DATE(' 2016-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160501_20160531 values less than (TO_DATE(' 2016-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160601_20160630 values less than (TO_DATE(' 2016-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160701_20160731 values less than (TO_DATE(' 2016-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160801_20160831 values less than (TO_DATE(' 2016-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20160901_20160930 values less than (TO_DATE(' 2016-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20161001_20161031 values less than (TO_DATE(' 2016-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20161101_20161130 values less than (TO_DATE(' 2016-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20161201_20161231 values less than (TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170101_20170131 values less than (TO_DATE(' 2017-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170201_20170228 values less than (TO_DATE(' 2017-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170301_20170331 values less than (TO_DATE(' 2017-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170401_20170430 values less than (TO_DATE(' 2017-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170501_20170531 values less than (TO_DATE(' 2017-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170601_20170630 values less than (TO_DATE(' 2017-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170701_20170731 values less than (TO_DATE(' 2017-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170801_20170831 values less than (TO_DATE(' 2017-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20170901_20170930 values less than (TO_DATE(' 2017-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20171001_20171031 values less than (TO_DATE(' 2017-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20171101_20171130 values less than (TO_DATE(' 2017-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20171201_20171231 values less than (TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180101_20180131 values less than (TO_DATE(' 2018-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180201_20180228 values less than (TO_DATE(' 2018-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180301_20180331 values less than (TO_DATE(' 2018-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180401_20180430 values less than (TO_DATE(' 2018-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180501_20180531 values less than (TO_DATE(' 2018-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180601_20180630 values less than (TO_DATE(' 2018-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180701_20180731 values less than (TO_DATE(' 2018-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180801_20180831 values less than (TO_DATE(' 2018-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20180901_20180930 values less than (TO_DATE(' 2018-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20181001_20181031 values less than (TO_DATE(' 2018-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20181101_20181130 values less than (TO_DATE(' 2018-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition P20181201_20181231 values less than (TO_DATE(' 2019-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    ),
  partition PFUTURE values less than (MAXVALUE)
    tablespace PC_LINK_DATA_TS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 1M
      minextents 1
      maxextents unlimited
    )
)
;
-- Create/Recreate indexes 
create index PC_LINK_ATTACHMENT_IDX1 on PC_LINK_ATTACHMENT (PXOBJCLASS, PXINSNAME, PXLINKEDREFFROM)
  tablespace PC_LINK_DATA_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 1M
    minextents 1
    maxextents unlimited
  );
create index PC_LINK_ATTACHMENT_IDX2 on PC_LINK_ATTACHMENT (PXLINKEDREFTO)
  tablespace PC_LINK_DATA_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 1M
    minextents 1
    maxextents unlimited
  );
create index PC_LINK_ATTACHMENT_IDX3 on PC_LINK_ATTACHMENT (PXLINKEDREFFROM)
  tablespace PC_LINK_DATA_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 1M
    minextents 1
    maxextents unlimited
  );
create unique index PC_LINK_ATTACHMENT_NEW_PK on PC_LINK_ATTACHMENT (PZINSKEY)
  tablespace PC_LINK_DATA_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 1M
    minextents 1
    maxextents unlimited
  );