1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Sharing column for partitions.

Discussion in 'SQL PL/SQL' started by Alexey.Samoilov, Apr 3, 2014.

  1. Alexey.Samoilov

    Alexey.Samoilov Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Is it High_value?
    Code (Text):

    SELECT partition_name, high_value
    FROM all_tab_partitions
    WHERE table_name='tab1';
     
     
  2. Alexey.Samoilov

    Alexey.Samoilov Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    How can I knew by what column partitions were shared?
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
  4. Alexey.Samoilov

    Alexey.Samoilov Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    I mean this view dba_part_key_columns, thanks
     
  5. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Or it is possible to use user/all_part_key_columns
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What do you mean by 'shared'?