Oracle Database Discussions

Hi All,

i have one existing table " TMP_CST_BLDG_COSTS_FCT" in which two partition already created. i need to add one more partition "TMP_CST_BLDG_COSTS_FCT_CGICS" based on value(10).

PARTITION BY LIST (CSBCF_CSCSD_KEY)
(
PARTITION TMP_CST_BLDG_COSTS_FCT_ESSBASE VALUES (9)
LOGGING
NOCOMPRESS
TABLESPACE CRSDW
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
),
PARTITION TMP_CST_BLDG_COSTS_FCT_OTHER VALUES (DEFAULT)
LOGGING
NOCOMPRESS
TABLESPACE CRSDW
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
)

When i am adding one more partition it gives error : ora-14323 : can not add partition when DEFAULT partition exists. please guide me how to add partition in table.

Thanks & regards
shyam