Modify Partition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Modify Partition

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    I have a partition table that is partitioned by date. the last partition has a high value of 6/1/02. I want to change that to 8/1/02. How do I do it? Here is what I think:

    alter table mytable
    modify partition PART_MAY2002
    high_value to_date('20020801','YYYYMMDD');

    Here is the error I get
    *
    ERROR at line 3:
    ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The valid options you can use in ALTER TABLE MODIFY PARTITION are PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, BACKUP, ALLOCATE EXTENT, or DEALLOCATE UNUSED.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    Try with this

    UPDATE MYTABLE PARTITION(PART_MAY2002)
    SET high_value=to_date('20020801','YYYYMMDD');

    Cheers

    Angel

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You will have to use "alter table ... split partition".
    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
    Jan 2001
    Posts
    515

    spilt partition ???

    Can you be more specific on split partition please???

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Based on the original post requirenments I think what realy needs to be done here is:

    - add new partition with new high value (8/1/02)
    - merge both partitions into one using ALT#ER TABLE MERGE PARTITION clause
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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