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;

	/