Adding Partition to Partitioned Table
Johnny98Jul 16 2012 — edited Jul 16 2012Hello,
I have a partitioned table with 7 existing Partitions that follow this structure:
PARTITION "TRANSACTIONS_JAN2012" VALUES LESS THAN (TO_DATE(
' 2012-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 NOLOGGING STORAGE(INITIAL
1073741824 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT) TABLESPACE "FTSV1" NOCOMPRESS
I'm trying to add a new Partition:
alter table transactions add partition
(partition TRANSACTIONS_JTS VALUES LESS THAN (TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')));
But keep getting this error:
SQL Error: ORA-00902: invalid datatype
00902. 00000 - "invalid datatype"
Any help is greatly appreciated.
Thanks in advance,
Johnny