drop table TABLE_OWNER.NEW_TABLE cascade constraints
CREATE TABLE TABLE_OWNER.NEW_TABLE
(
ID NUMBER(12) NOT NULL,
APP_ID VARCHAR2(20) ,
APPLICATION VARCHAR2(20) ,
OPERATION VARCHAR2(255) ,
START_TIME TIMESTAMP(6) default current_timestamp not null,
END_TIME TIMESTAMP(6),
)
TABLESPACE TABLE_OWNER_TBSP
LOGGING
compress
partition by range (START_TIME)
(
PARTITION P_200901 VALUES LESS THAN (
TO_DATE(' 2009-01-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS',
'NLS_CALENDAR=GREGORIAN'))
LOGGING
COMPRESS
TABLESPACE TABLE_OWNER);
--#
--# Wir legen nur eine Parition an, alle
--# weiteren Parttionen lassen wir automatisch
--# vom Partitionierungstool anlegen
--#
begin
for i in 1..24 loop
TABLE_OWNER.psm_pt.crpt( 'NEW_TABLE',
'MONTH',
'TABLE_OWNER',
add_months(
to_date('20090101','yyyymmdd'),
i
)
);
end loop;
end;
/