Uptime - Oracle 'Create Table' Generator for Table Partitioning

Current Date/Time: 2023-03-21 03:04:49

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_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')),
PARTITION ups_2022_10 VALUES LESS THAN (TO_DATE('01-11-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_11 VALUES LESS THAN (TO_DATE('01-12-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_12 VALUES LESS THAN (TO_DATE('01-01-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_01 VALUES LESS THAN (TO_DATE('01-02-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_02 VALUES LESS THAN (TO_DATE('01-03-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_03 VALUES LESS THAN (TO_DATE('01-04-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_04 VALUES LESS THAN (TO_DATE('01-05-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_05 VALUES LESS THAN (TO_DATE('01-06-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_06 VALUES LESS THAN (TO_DATE('01-07-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_07 VALUES LESS THAN (TO_DATE('01-08-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_08 VALUES LESS THAN (TO_DATE('01-09-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_09 VALUES LESS THAN (TO_DATE('01-10-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_10 VALUES LESS THAN (TO_DATE('01-11-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_11 VALUES LESS THAN (TO_DATE('01-12-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_12 VALUES LESS THAN (TO_DATE('01-01-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_01 VALUES LESS THAN (TO_DATE('01-02-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_02 VALUES LESS THAN (TO_DATE('01-03-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_03 VALUES LESS THAN (TO_DATE('01-04-2024', '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_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')),
PARTITION ups_2022_10 VALUES LESS THAN (TO_DATE('01-11-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_11 VALUES LESS THAN (TO_DATE('01-12-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_12 VALUES LESS THAN (TO_DATE('01-01-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_01 VALUES LESS THAN (TO_DATE('01-02-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_02 VALUES LESS THAN (TO_DATE('01-03-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_03 VALUES LESS THAN (TO_DATE('01-04-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_04 VALUES LESS THAN (TO_DATE('01-05-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_05 VALUES LESS THAN (TO_DATE('01-06-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_06 VALUES LESS THAN (TO_DATE('01-07-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_07 VALUES LESS THAN (TO_DATE('01-08-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_08 VALUES LESS THAN (TO_DATE('01-09-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_09 VALUES LESS THAN (TO_DATE('01-10-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_10 VALUES LESS THAN (TO_DATE('01-11-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_11 VALUES LESS THAN (TO_DATE('01-12-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_12 VALUES LESS THAN (TO_DATE('01-01-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_01 VALUES LESS THAN (TO_DATE('01-02-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_02 VALUES LESS THAN (TO_DATE('01-03-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_03 VALUES LESS THAN (TO_DATE('01-04-2024', '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_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')),
PARTITION ups_2022_10 VALUES LESS THAN (TO_DATE('01-11-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_11 VALUES LESS THAN (TO_DATE('01-12-2022', 'DD-MM-YYYY')),
PARTITION ups_2022_12 VALUES LESS THAN (TO_DATE('01-01-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_01 VALUES LESS THAN (TO_DATE('01-02-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_02 VALUES LESS THAN (TO_DATE('01-03-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_03 VALUES LESS THAN (TO_DATE('01-04-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_04 VALUES LESS THAN (TO_DATE('01-05-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_05 VALUES LESS THAN (TO_DATE('01-06-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_06 VALUES LESS THAN (TO_DATE('01-07-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_07 VALUES LESS THAN (TO_DATE('01-08-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_08 VALUES LESS THAN (TO_DATE('01-09-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_09 VALUES LESS THAN (TO_DATE('01-10-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_10 VALUES LESS THAN (TO_DATE('01-11-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_11 VALUES LESS THAN (TO_DATE('01-12-2023', 'DD-MM-YYYY')),
PARTITION ups_2023_12 VALUES LESS THAN (TO_DATE('01-01-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_01 VALUES LESS THAN (TO_DATE('01-02-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_02 VALUES LESS THAN (TO_DATE('01-03-2024', 'DD-MM-YYYY')),
PARTITION ups_2024_03 VALUES LESS THAN (TO_DATE('01-04-2024', 'DD-MM-YYYY'))
)
/

Email:
Password:

My Uptime IM

Uptime - Oracle 'Create Table' Generator for Table Partitioning