ORA-14020:this physical attribute may not be specified for table partition
816803Nov 19 2010 — edited Nov 19 2010I am Trying to split a Partition from a MAXVAL partition ,But i am getting an error shownb below . Kindly please Help , Need your Suggestions .
Alter table ABCDEFG split partition RMAXVALUE at (TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into
(
PARTITION R20100331 VALUES LESS THAN (TO_DATE(' 2010-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE *********1
PCTUSED 40
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128M
NEXT 105M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 2
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
PARTITION R20100630 VALUES LESS THAN (TO_DATE(' 2010-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE *********
PCTUSED 40
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128M
NEXT 105M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 2
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
PARTITION R20100930 VALUES LESS THAN (TO_DATE(' 2010-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE *********
PCTUSED 40
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128M
NEXT 105M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 2
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
PARTITION R20101231 VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE *********
PCTUSED 40
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128M
NEXT 105M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 2
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
PARTITION RMAXVAL1 VALUES LESS THAN (MAXVALUE)
LOGGING
NOCOMPRESS
TABLESPACE *********
PCTUSED 40
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128M
NEXT 105M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 2
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
)
NOCOMPRESS
NOCACHE
PARALLEL ( DEGREE 4 INSTANCES DEFAULT )
NOMONITORING;
**Error : PARTITION R20100331 VALUES LESS THAN (TO_DATE(' 2010-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))**
*****
**ERROR at line 3:**
**ORA-14020: this physical attribute may not be specified for a table partition**