up.time - Oracle 11g Generator for Table Partitioning

Current Date/Time: 2012-05-17 12:49:13
Number of Partitions selected: 12

Change number of partitions:

set serveroutput on;
set pagesize 1000;
set linesize 1000;
-- Start of PERFORMANCE_SAMPLE --
---------------------------------
-- Clean before trying...
DROP TABLE PERFORMANCE_DELETE CASCADE CONSTRAINTS PURGE
/

EXEC DBMS_OUTPUT.put_line('Please enter the tablespace where partitioned tables will reside.')

-- With Range Partitioning --
CREATE TABLE PERFORMANCE_DELETE (
"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_2011_06 VALUES LESS THAN (TO_DATE('1-07-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_07 VALUES LESS THAN (TO_DATE('1-08-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_08 VALUES LESS THAN (TO_DATE('1-09-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_09 VALUES LESS THAN (TO_DATE('1-10-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_10 VALUES LESS THAN (TO_DATE('1-11-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_11 VALUES LESS THAN (TO_DATE('1-12-2011', 'DD-MM-YYYY')),
PARTITION ups_2011_12 VALUES LESS THAN (TO_DATE('1-01-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_01 VALUES LESS THAN (TO_DATE('1-02-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_02 VALUES LESS THAN (TO_DATE('1-03-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_03 VALUES LESS THAN (TO_DATE('1-04-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_04 VALUES LESS THAN (TO_DATE('1-05-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_05 VALUES LESS THAN (TO_DATE('1-06-2012', 'DD-MM-YYYY')),
PARTITION ups_2012_06 VALUES LESS THAN (TO_DATE('1-07-2012', 'DD-MM-YYYY'))
)

TABLESPACE &&tablespace_for_tables
/

My up.time

Resources

Contact Support

Hours

up.time - Oracle 11g Generator for Table Partitioning