ora-14020 on split partition

[DBAtrix]

i'm not sure what to do with this error.

SQL> r
1 select partition_NAME, PARTITION_POSITION, HIGH_VALUE from
2 user_tab_partitions
3 where table_name ='PT_PAGE_EVENTS'
4* order by 2

PARTITION_NAME PARTITION_POSITION HIGH_VALUE
------------------------------ ------------------ ------------
P_2002_01_16_DAY_HUB1 1 381, 2
P_2002_01_16_DAY_HUB2 2 381, 3
P_2002_01_16_DAY_HUB3 3 381, 4
P_2002_01_17_DAY_HUB1 4 382, 2
P_2002_01_17_DAY_HUB2 5 382, 3
P_2002_01_17_DAY_HUB3 6 382, 4
P_2002_01_18_DAY_HUB1 7 383, 2
P_2002_01_18_DAY_HUB2 8 383, 3
P_2002_01_18_DAY_HUB3 9 383, 4

9 rows selected.

SQL> l
1 alter table pt_page_events
2 split partition P_2002_01_16_DAY_HUB1 at ( 356, 2 )
3 into (
4 partition p_2001_12_22_DAY_HUB1
5 partition P_2002_01_16_DAY_HUB1
6* )
SQL> /
partition P_2002_01_16_DAY_HUB1
*
ERROR at line 5:
ORA-14020: this physical attribute may not be specified for a table partition
SQL> r
1 alter table pt_page_events
2 split partition P_2002_01_16_DAY_HUB1 at ( 356, 2 )
3 into (
4 partition p_2001_12_22_DAY_HUB1
5 partition P_2002_01_16_DAY_HUB1a
6* )
partition P_2002_01_16_DAY_HUB1a
*
ERROR at line 5:
ORA-14020: this physical attribute may not be specified for a table partition

i can't figure out what is wrong with this syntax!!! what am i missing or not understanding?

thx. d.

[marist89]

Try:

SQL> l
alter table pt_page_events
split partition P_2002_01_16_DAY_HUB1 at ( 356, 2 )
into (
partition p_2001_12_22_DAY_HUB1,
partition P_2002_01_16_DAY_HUB1
)

[DBAtrix]

duuuh. i can't tell you how many times i looked at that. if it were Lent, at least i could claim i gave up commas.

thx, jeff.

[marist89]

Sometimes the most obvious eludes us.

[sonofsita]

If you are not on 8.1.6 you are hitting bug 843361, fixed in 8.1.6. It is a problem with partitioned table with a varray column which tries to do a varray store as lob at the partition level.

[sonofsita]

you may also look into this metalink doc

http://metalink.oracle.com/metalink/...T&p_id=96933.1

[pando]

miss a coma is a bug huh