Uptime - Oracle 'Create Table' Generator for Table Partitioning

Current Date/Time: 2021-09-17 08:27:07

By default we'll setup enough partitions for the past year and 1 year into the future. All future partitions will be automatically created by the database.

This is:

set serveroutput on;
set pagesize 1000;
set linesize 1000;

---------------------------------
-- Start of PERFORMANCE_SAMPLE_PAR --
---------------------------------
-- With Range Partitioning --
CREATE TABLE PERFORMANCE_SAMPLE_PAR (
"ID" NUMBER(20) NOT NULL,
"ERDC_ID" NUMBER(20),
"UPTIMEHOST_ID" NUMBER(20) NOT NULL,
"SAMPLE_TIME" TIMESTAMP(6) NOT NULL,
PRIMARY KEY ("ID") VALIDATE
)
PARTITION BY RANGE (sample_time) (
PARTITION ups_2020_09 VALUES LESS THAN (TO_DATE('01-10-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_10 VALUES LESS THAN (TO_DATE('01-11-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_11 VALUES LESS THAN (TO_DATE('01-12-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_12 VALUES LESS THAN (TO_DATE('01-01-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_01 VALUES LESS THAN (TO_DATE('01-02-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_02 VALUES LESS THAN (TO_DATE('01-03-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_03 VALUES LESS THAN (TO_DATE('01-04-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_04 VALUES LESS THAN (TO_DATE('01-05-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_05 VALUES LESS THAN (TO_DATE('01-06-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_06 VALUES LESS THAN (TO_DATE('01-07-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_07 VALUES LESS THAN (TO_DATE('01-08-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_08 VALUES LESS THAN (TO_DATE('01-09-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_09 VALUES LESS THAN (TO_DATE('01-10-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_10 VALUES LESS THAN (TO_DATE('01-11-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_11 VALUES LESS THAN (TO_DATE('01-12-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_12 VALUES LESS THAN (TO_DATE('01-01-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_01 VALUES LESS THAN (TO_DATE('01-02-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_02 VALUES LESS THAN (TO_DATE('01-03-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_03 VALUES LESS THAN (TO_DATE('01-04-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_04 VALUES LESS THAN (TO_DATE('01-05-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_05 VALUES LESS THAN (TO_DATE('01-06-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_06 VALUES LESS THAN (TO_DATE('01-07-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_07 VALUES LESS THAN (TO_DATE('01-08-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_08 VALUES LESS THAN (TO_DATE('01-09-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_09 VALUES LESS THAN (TO_DATE('01-10-2022', 'DD-MM-YYYY'))
)
/

------------------------------------
-- Start of ERDC_INT_DATA --
------------------------------------
-- With Interval Partitioning --
CREATE TABLE ERDC_INT_DATA_PAR (
"ERDC_INT_DATA_ID" NUMBER(20) NOT NULL,
"ERDC_INSTANCE_ID" NUMBER(20),
"ERDC_PARAMETER_ID" NUMBER(20),
"VALUE" NUMBER(20),
"SAMPLETIME" TIMESTAMP(6) NOT NULL,
PRIMARY KEY ("ERDC_INT_DATA_ID") VALIDATE
)
PARTITION BY RANGE (sampletime)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION erdc_int_p1 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY'))
)
/

------------------------------------
-- Start of ERDC_DECIMAL_DATA --
------------------------------------
-- With Interval Partitioning --
CREATE TABLE ERDC_DECIMAL_DATA_PAR (
"ERDC_INT_DATA_ID" NUMBER(20),
"ERDC_INSTANCE_ID" NUMBER(20),
"ERDC_PARAMETER_ID" NUMBER(20),
"VALUE" FLOAT(126),
"SAMPLETIME" TIMESTAMP(6) NOT NULL,
PRIMARY KEY ("ERDC_INT_DATA_ID") VALIDATE )
PARTITION BY RANGE (sampletime)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION erdc_dec_p1 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY'))
)
/

------------------------------------
-- Start of ERDC_STRING_DATA --
------------------------------------
-- With Interval Partitioning --
CREATE TABLE ERDC_STRING_DATA_PAR (
"ERDC_INT_DATA_ID" NUMBER(20) NOT NULL,
"ERDC_INSTANCE_ID" NUMBER(20),
"ERDC_PARAMETER_ID" NUMBER(20),
"VALUE" CLOB,
"SAMPLETIME" TIMESTAMP(6) NOT NULL,
PRIMARY KEY ("ERDC_INT_DATA_ID") VALIDATE
)
PARTITION BY RANGE (sampletime)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION erdc_string_p1 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY'))
)
/

------------------------------------
-- Start of RANGED_OBJECT_VALUE --
------------------------------------
-- With Interval Partitioning --
CREATE TABLE RANGED_OBJECT_VALUE_PAR (
"ID" NUMBER(20) NOT NULL,
"RANGED_OBJECT_ID" NUMBER(20),
"NAME" VARCHAR2(255),
"VALUE" FLOAT(126),
"SAMPLE_TIME" TIMESTAMP(6) NOT NULL,
CONSTRAINT FK_RANGED_OBJECT_VALUE
FOREIGN KEY ("RANGED_OBJECT_ID")
REFERENCES RANGED_OBJECT ("ID") VALIDATE ,
PRIMARY KEY ("ID") VALIDATE
)
PARTITION BY RANGE (sample_time)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION ranged_object_p1 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY'))
)
/

-- New tables in up.time 6.0 --

CREATE TABLE VMWP_SAMPLE_PAR (
"SAMPLE_ID" NUMBER(20),
"VMWARE_OBJECT_TYPE" VARCHAR2(255),
"VMWARE_OBJECT_ID" NUMBER(20),
"VIRTUAL_CENTER_ID" NUMBER(20),
"DATACENTER_ID" NUMBER(20),
"CLUSTER_ID" NUMBER(20),
"HOST_SYSTEM_ID" NUMBER(20),
"RESOURCE_POOL_ID" NUMBER(20),
"SAMPLE_TIME" TIMESTAMP(6),
PRIMARY KEY ("SAMPLE_ID") VALIDATE
)
PARTITION BY RANGE (sample_time) (
PARTITION ups_2020_09 VALUES LESS THAN (TO_DATE('01-10-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_10 VALUES LESS THAN (TO_DATE('01-11-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_11 VALUES LESS THAN (TO_DATE('01-12-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_12 VALUES LESS THAN (TO_DATE('01-01-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_01 VALUES LESS THAN (TO_DATE('01-02-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_02 VALUES LESS THAN (TO_DATE('01-03-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_03 VALUES LESS THAN (TO_DATE('01-04-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_04 VALUES LESS THAN (TO_DATE('01-05-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_05 VALUES LESS THAN (TO_DATE('01-06-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_06 VALUES LESS THAN (TO_DATE('01-07-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_07 VALUES LESS THAN (TO_DATE('01-08-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_08 VALUES LESS THAN (TO_DATE('01-09-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_09 VALUES LESS THAN (TO_DATE('01-10-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_10 VALUES LESS THAN (TO_DATE('01-11-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_11 VALUES LESS THAN (TO_DATE('01-12-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_12 VALUES LESS THAN (TO_DATE('01-01-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_01 VALUES LESS THAN (TO_DATE('01-02-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_02 VALUES LESS THAN (TO_DATE('01-03-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_03 VALUES LESS THAN (TO_DATE('01-04-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_04 VALUES LESS THAN (TO_DATE('01-05-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_05 VALUES LESS THAN (TO_DATE('01-06-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_06 VALUES LESS THAN (TO_DATE('01-07-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_07 VALUES LESS THAN (TO_DATE('01-08-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_08 VALUES LESS THAN (TO_DATE('01-09-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_09 VALUES LESS THAN (TO_DATE('01-10-2022', 'DD-MM-YYYY'))
)
/

-- New tables in Uptime7.0 --

CREATE TABLE "NET_DP_SAMPLE_PAR" (
"ID" NUMBER(20),
"ENTITY_ID" NUMBER(20),
"SAMPLE_TIME" TIMESTAMP(6),
PRIMARY KEY (ID) VALIDATE
)
PARTITION BY RANGE (sample_time) (
PARTITION ups_2020_09 VALUES LESS THAN (TO_DATE('01-10-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_10 VALUES LESS THAN (TO_DATE('01-11-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_11 VALUES LESS THAN (TO_DATE('01-12-2020', 'DD-MM-YYYY')),
PARTITION ups_2020_12 VALUES LESS THAN (TO_DATE('01-01-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_01 VALUES LESS THAN (TO_DATE('01-02-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_02 VALUES LESS THAN (TO_DATE('01-03-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_03 VALUES LESS THAN (TO_DATE('01-04-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_04 VALUES LESS THAN (TO_DATE('01-05-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_05 VALUES LESS THAN (TO_DATE('01-06-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_06 VALUES LESS THAN (TO_DATE('01-07-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_07 VALUES LESS THAN (TO_DATE('01-08-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_08 VALUES LESS THAN (TO_DATE('01-09-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_09 VALUES LESS THAN (TO_DATE('01-10-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_10 VALUES LESS THAN (TO_DATE('01-11-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_11 VALUES LESS THAN (TO_DATE('01-12-2021', 'DD-MM-YYYY')),
PARTITION ups_2021_12 VALUES LESS THAN (TO_DATE('01-01-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_01 VALUES LESS THAN (TO_DATE('01-02-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_02 VALUES LESS THAN (TO_DATE('01-03-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_03 VALUES LESS THAN (TO_DATE('01-04-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_04 VALUES LESS THAN (TO_DATE('01-05-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_05 VALUES LESS THAN (TO_DATE('01-06-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_06 VALUES LESS THAN (TO_DATE('01-07-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_07 VALUES LESS THAN (TO_DATE('01-08-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_08 VALUES LESS THAN (TO_DATE('01-09-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_09 VALUES LESS THAN (TO_DATE('01-10-2022', 'DD-MM-YYYY'))
)
/

Email:
Password:

My Uptime IM

Uptime - Oracle 'Create Table' Generator for Table Partitioning