-- sample_CONTENT.ddl

CREATE TABLE CONTENT (
  ELEMENT_ID	VARGRAPHIC(48)	NOT NULL,
  EXTENSION	VARGRAPHIC(3),
  CONTENT	BLOB(1G)	 INLINE LENGTH 276	LOGGED	NOT COMPACT,
  CONTENT_SIZE	INTEGER	NOT NULL,
  CREATE_DATE	TIMESTAMP,
  REFCOUNT	INTEGER,
  SCF_DATA	VARCHAR(32) FOR BIT DATA
  ) 
  INDEX IN CONPART000X
  PARTITION BY RANGE ( CREATE_DATE NULLS FIRST ) (
      PARTITION CONPART001 STARTING MINVALUE INCLUSIVE  ENDING '2018-01-01-00.00.00.000000' EXCLUSIVE IN CONPART001T INDEX IN CONPART001X LONG IN CONPART001L,
      PARTITION CONPART002 STARTING '2018-01-01-00.00.00.000000' INCLUSIVE  ENDING '2019-01-01-00.00.00.000000' EXCLUSIVE IN CONPART002T INDEX IN CONPART002X LONG IN CONPART002L,
      PARTITION CONPART003 STARTING '2019-01-01-00.00.00.000000' INCLUSIVE  ENDING '2020-01-01-00.00.00.000000' EXCLUSIVE IN CONPART003T INDEX IN CONPART003X LONG IN CONPART003L,
      PARTITION CONPART004 STARTING '2020-01-01-00.00.00.000000' INCLUSIVE  ENDING '2021-01-01-00.00.00.000000' EXCLUSIVE IN CONPART004T INDEX IN CONPART004X LONG IN CONPART004L,
      PARTITION CONPART005 STARTING '2021-01-01-00.00.00.000000' INCLUSIVE  ENDING '2022-01-01-00.00.00.000000' EXCLUSIVE IN CONPART005T INDEX IN CONPART005X LONG IN CONPART005L,
      PARTITION CONPART006 STARTING '2022-01-01-00.00.00.000000' INCLUSIVE  ENDING '2023-01-01-00.00.00.000000' EXCLUSIVE IN CONPART006T INDEX IN CONPART006X LONG IN CONPART006L,
      PARTITION CONPART007 STARTING '2023-01-01-00.00.00.000000' INCLUSIVE  ENDING '2024-01-01-00.00.00.000000' EXCLUSIVE IN CONPART007T INDEX IN CONPART007X LONG IN CONPART007L,
      PARTITION CONPART008 STARTING '2024-01-01-00.00.00.000000' INCLUSIVE  ENDING MAXVALUE                     INCLUSIVE IN CONPART008T INDEX IN CONPART008X LONG IN CONPART008L )
  COMPRESS YES ADAPTIVE
  ORGANIZE BY ROW;

ALTER TABLE CONTENT
  DATA CAPTURE NONE
  PCTFREE 0
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;


ALTER TABLE CONTENT
  ADD PRIMARY KEY
    (ELEMENT_ID)
    ENFORCED;

COMMIT;


RUNSTATS ON TABLE CONTENT
	AND INDEXES ALL
	ALLOW READ ACCESS;


RUNSTATS ON TABLE CONTENT ON ALL COLUMNS WITH DISTRIBUTION ON ALL COLUMNS AND SAMPLED DETAILED INDEXES ALL
SET PROFILE ONLY;