I create a composite list by list partition table received the above error when importing the data.
where do i put the default clause in my create table statement
1.the partition or subpartition
here is an example of my create table statement
CREATE TABLE L21M
(
DESCRIPTION VARCHAR2(60 BYTE),
REFERENCE_1 CHAR(10 BYTE),
REFERENCE_2 CHAR(10 BYTE),
USER_NAME CHAR(8 BYTE) NOT NULL,
POSTING_PERIOD NUMBER(2) NOT NULL,
POSTING_YEAR NUMBER(4) NOT NULL,
LINE_NUMBER NUMBER(8) NOT NULL,
DEBIT_VALUE NUMBER(13,2) NOT NULL,
CREDIT_VALUE NUMBER(13,2) NOT NULL,
PRINTED_FLAG CHAR(1 BYTE),
CRED_CODE CHAR(6 BYTE),
)
TABLESPACE Users
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
PARTITION BY LIST (POSTING_YEAR)
SUBPARTITION BY LIST (POSTING_PERIOD)
( PARTITION L21M_2006_2012 VALUES (2006,2012)
( SUBPARTITION L21M_2006_2012_01 VALUES (01)
, SUBPARTITION L21M_2006_2012_02 VALUES (02)
, SUBPARTITION L21M_2006_2012_03 VALUES (03)
, SUBPARTITION L21M_2006_2012_04 VALUES (04)
, SUBPARTITION L21M_2006_2012_05 VALUES (05)
, SUBPARTITION L21M_2006_2012_06 VALUES (06)
, SUBPARTITION L21M_2006_2012_07 VALUES (07)
, SUBPARTITION L21M_2006_2012_08 VALUES (08)
, SUBPARTITION L21M_2006_2012_09 VALUES (09)
, SUBPARTITION L21M_2006_2012_10 VALUES (10)
, SUBPARTITION L21M_2006_2012_11 VALUES (11)
, SUBPARTITION L21M_2006_2012_12 VALUES (12)
)
, PARTITION L21M_2007_2013 VALUES (2007,2013)
( SUBPARTITION L21M_2007_2013_01 VALUES (01)
, SUBPARTITION L21M_2007_2013_02 VALUES (02)
, SUBPARTITION L21M_2007_2013_03 VALUES (03)
, SUBPARTITION L21M_2007_2013_04 VALUES (04)
, SUBPARTITION L21M_2007_2013_05 VALUES (05)
, SUBPARTITION L21M_2007_2013_06 VALUES (06)
, SUBPARTITION L21M_2007_2013_07 VALUES (07)
, SUBPARTITION L21M_2007_2013_08 VALUES (08)
, SUBPARTITION L21M_2007_2013_09 VALUES (09)
, SUBPARTITION L21M_2007_2013_10 VALUES (10)
, SUBPARTITION L21M_2007_2013_11 VALUES (11)
, SUBPARTITION L21M_2007_2013_12 VALUES (12)
)
, PARTITION L21M_2008_2014 VALUES (2008,2014)
( SUBPARTITION L21M_2008_2014_01 VALUES (01)
, SUBPARTITION L21M_2008_2014_02 VALUES (02)
, SUBPARTITION L21M_2008_2014_03 VALUES (03)
, SUBPARTITION L21M_2008_2014_04 VALUES (04)
, SUBPARTITION L21M_2008_2014_05 VALUES (05)
, SUBPARTITION L21M_2008_2014_06 VALUES (06)
, SUBPARTITION L21M_2008_2014_07 VALUES (07)
, SUBPARTITION L21M_2008_2014_08 VALUES (08)
, SUBPARTITION L21M_2008_2014_09 VALUES (09)
, SUBPARTITION L21M_2008_2014_10 VALUES (10)
, SUBPARTITION L21M_2008_2014_11 VALUES (11)
, SUBPARTITION L21M_2008_2014_12 VALUES (12)
)
, PARTITION L21M_2009_2015 VALUES (2009,2015)
( SUBPARTITION L21M_2009_2015_01 VALUES (01)
, SUBPARTITION L21M_2009_2015_02 VALUES (02)
, SUBPARTITION L21M_2009_2015_03 VALUES (03)
, SUBPARTITION L21M_2009_2015_04 VALUES (04)
, SUBPARTITION L21M_2009_2015_05 VALUES (05)
, SUBPARTITION L21M_2009_2015_06 VALUES (06)
, SUBPARTITION L21M_2009_2015_07 VALUES (07)
, SUBPARTITION L21M_2009_2015_08 VALUES (08)
, SUBPARTITION L21M_2009_2015_09 VALUES (09)
, SUBPARTITION L21M_2009_2015_10 VALUES (10)
, SUBPARTITION L21M_2009_2015_11 VALUES (11)
, SUBPARTITION L21M_2009_2015_12 VALUES (12)
)
Any help will be highly appreciated