ora-14020 on split partition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-14020 on split partition

  1. #1
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Try:
    Code:
    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
    )
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sometimes the most obvious eludes us.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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
    http://www.ordba.net

  6. #6
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    you may also look into this metalink doc

    http://metalink.oracle.com/metalink/...T&p_id=96933.1
    sonofsita
    http://www.ordba.net

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    miss a coma is a bug huh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width