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

Thread: split partitions

Threaded View

  1. #4
    Join Date
    Sep 2001
    Posts
    200
    I was also looking a ask a question about partition split. I have this example that i saw somewhere out there...

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

    then follows this select/verification
    COLUMN high_value FORMAT A20
    SELECT table_name,
    partition_name,
    high_value,
    num_rows
    FROM user_tab_partitions
    ORDER BY table_name, partition_name;

    TABLE_NAME PARTITION_NAME HIGH_VALUE NUM_ROWS
    ----------- ------------ --------- ---------- ------------- ----------
    MY_TABLE MY_TABLE_PART_1 3 2
    MY_TABLE MY_TABLE_PART_2 MAXVALUE 2

    My questions is...where does the (3) as in At (3) above come from?
    I would have thought it comes from the HIGH_VALUE column of the table to be split?
    but my does not return anything..
    SQL> select high_value from user_tab_partitions where table_name ='AAS_AON_FCT_2004_Q4';

    no rows selected
    Thanks
    Last edited by ndisang; 04-02-2007 at 11:23 AM.
    Life is what is happening today while you were planning tomorrow.

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