Subpartition template
Use a subpartition template to automatically create subpartitions. –Create new table NEW_TABLE if this has not already happened DECLARE table_exists NUMBER :=0; BEGIN SELECT COUNT(*) INTO table_exists FROM USER_TABLES WHERE TABLE_NAME = ‘NEW_TABLE’; IF table_exists = 0 THEN EXECUTE IMMEDIATE(q'{ …