ORA-14020: this physical attribute may not be specified for a table partition
Cause:
Silly ! Syntax issue like Commas or braces missing ~Dont scratch your head and waste your time figuring out
PARTITION BY RANGE (ORDER_DATE)
(PARTITION P_S1 VALUES LESS THAN (TO_DATE('01/01/2012','DD/MM/YYYY'))
(PARTITION P_S2 VALUES LESS THAN (TO_DATE('01/01/2015','DD/MM/YYYY')) <----------
(PARTITION P_S3 VALUES LESS THAN (TO_DATE(MAXVALUE)); 5 6 7 8 9 10 11 12 13 14 15 16 17 18
(PARTITION P_S2 VALUES LESS THAN (TO_DATE('01/01/2015','DD/MM/YYYY')) <----------
*
ERROR at line 17:
ORA-14020: this physical attribute may not be specified for a table partition
Solution:
Give the correct syntax with correct quotations and braces on the query
PARTITION BY RANGE (ORDER_DATE)
(PARTITION P_S1 VALUES LESS THAN (TO_DATE('01-01-2012','DD-MM-YYYY')),
PARTITION P_S2 VALUES LESS THAN (TO_DATE('01-01-2015','DD-MM-YYYY')),
PARTITION P_S3 VALUES LESS THAN (TO_DATE('01-01-2018','DD-MM-YYYY')),
PARTITION P_S4 VALUES LESS THAN (TO_DATE('01-01-2021','DD-MM-YYYY')),
PARTITION P_S5 VALUES LESS THAN (TO_DATE('01-01-2024','DD-MM-YYYY')),
PARTITION P_S6 VALUES LESS THAN (TO_DATE('01-01-2027','DD-MM-YYYY')),
PARTITION P_S7 VALUES LESS THAN (TO_DATE('01-01-2030','DD-MM-YYYY')),
PARTITION P_S8 VALUES LESS THAN (TO_DATE('01-01-2033','DD-MM-YYYY')),
PARTITION P_S9 VALUES LESS THAN (maxvalue));