DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Partitioning Problem

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Partitioning Problem

    Dear All,
    I am trying to practice for partitioning the tables
    I have created a partitioned table with the following

    CREATE TABLE my_table_2 (
    id NUMBER,
    description VARCHAR2(50)
    )
    PARTITION BY RANGE (id)
    (PARTITION my_table_part VALUES LESS THAN (MAXVALUE));

    INSERT INTO my_table (id, description) VALUES (1, 'One');
    INSERT INTO my_table (id, description) VALUES (2, 'Two');
    INSERT INTO my_table (id, description) VALUES (3, 'Three');
    INSERT INTO my_table (id, description) VALUES (4, 'Four');
    COMMIT;

    A partitioned table is created with a single partition,Now i want to split this partitioned table into multiple partition,i have split it into two partition with the following script

    ALTER TABLE my_table SPLIT PARTITION my_table_part AT (3)
    INTO (PARTITION my_table_part_1,
    PARTITION my_table_part_2);

    But My requirement is to split this partition table into more than two partition
    Can anybody help me in this regard by providing the syntax to do it?
    Thanx in advance

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Split one of the produced partitions again

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