error ORA-14020 with creating table
616696Mar 5 2008 — edited Mar 5 2008hi
I want to create table with partition list , I have 18 partition and when I Execute the script i see this error
ORA-14020: this physical attribute may not be specified for a table partition .
my script is :
CREATE TABLE "SCOTT"."Dtin_Curt" (
"Code" NUMBER(10) NOT NULL, "Dist_Tell"
VARCHAR2(16 byte) NOT NULL, "Call_Date" DATE NOT NULL, "Call_Time"
VARCHAR2(6 byte) NOT NULL, "Call_Durn" NUMBER(6) NOT NULL, "Plus_Numb"
NUMBER(6) NOT NULL, "File_Hstr_Code" NUMBER(8), "Swth_Type_Code"
NUMBER(10) NOT NULL, "Cntr_Code" NUMBER(10) NOT NULL, "Cycl"
NUMBER(4) NOT NULL, "Year" NUMBER(4) NOT NULL, "Swth_File_Code"
NUMBER(4) NOT NULL, "Tell" NUMBER(15) NOT NULL,
CONSTRAINT "SYS_C013047" PRIMARY KEY("Code", "Tell", "Cntr_Code")
USING INDEX
TABLESPACE "DETAIL" )
partition by list ("Cntr_Code")
(
partition "Dtin_Curt_P26" values (26) TABLESPACE "DETAIL",
partition "Dtin_Curt_135" values (135) TABLESPACE "DETAIL",
partition "Dtin_Curt_P88" values (88) TABLESPACE "DETAIL",
partition "Dtin_Curt_P78" values (78) TABLESPACE "DETAIL",
partition "Dtin_Curt_P5" values (5) TABLESPACE "DETAIL",
partition "Dtin_Curt_P91" values (91) TABLESPACE "DETAIL",
partition "Dtin_Curt_P92" values (92) TABLESPACE "DETAIL",
partition "Dtin_Curt_P93" values (93) TABLESPACE "DETAIL",
partition "Dtin_Curt_P94" values (94) TABLESPACE "DETAIL",
partition "Dtin_Curt_P95" values (95) TABLESPACE "DETAIL",
partition "Dtin_Curt_P96" values (96) TABLESPACE "DETAIL",
partition "Dtin_Curt_P97" values (97) TABLESPACE "DETAIL",
partition "Dtin_Curt_P98" values (98) TABLESPACE "DETAIL",
partition "Dtin_Curt_P87" values (87) TABLESPACE "DETAIL",
partition "Dtin_Curt_P99" values (99) TABLESPACE "DETAIL",
partition "Dtin_Curt_P100" values (100) TABLESPACE "DETAIL",
partition "Dtin_Curt_P101" values (101) TABLESPACE "DETAIL,
partition "Dtin_Curt_PDefault" values (Default) TABLESPACE "DETAIL" );