Oracle table dynamic partition

Oracle table dynamic partition

Create the table with interval
partitioning
:

CREATE TABLE TEJAS_CARD_REPORT(    "INSERT_DATETIME" TIMESTAMP (6) NOT NULL ENABLE,     "NAME"         VARCHAr2(100 BYTE),     "IPADDRESS" VARCHAr2(100 BYTE),     "PRODUCTCODE" VARCHAr2(100 BYTE),     "LCTNAME" VARCHAr2(100 BYTE),     "CARDTYPELABEL" VARCHAr2(100 BYTE),     "SOFTWAREVERSION" VARCHAr2(100 BYTE)) partition by range(insert_datetime) interval (interval '15' minute)(    partition initial_partition values less than (date '2000-01-01'));

Partitions are dynamically created as data is inserted.

insert into tejas_card_report(insert_datetime) values (timestamp '2000-01-01 00:14:00');insert into tejas_card_report(insert_datetime) values (timestamp '2000-01-01 00:29:00');insert into tejas_card_report(insert_datetime) values (timestamp '2000-10-11 00:00:00');SQL> select partition_name, high_value from dba_tab_partitions where table_name = 'TEJAS_CARD_REPORT';PARTITION_NAME       HIGH_VALUE-------------------- --------------------------------------------------------------------------------SYS_P21516TIMESTAMP' 2000-10-11 00:15:00'SYS_P21515TIMESTAMP' 2000-01-01 00:30:00'SYS_P21514TIMESTAMP' 2000-01-01 00:15:00'INITIAL_PARTITION    TIMESTAMP' 2000-01-01 00:00:00'

On an unrelated note, avoid

TABLESPACE "SYSTEM"

. You almost never want to
store any user or application data in the SYSTEM tablespace.