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!

Adding subpartitions in template

Discussion in 'SQL PL/SQL' started by NikoTrend1, Apr 4, 2014.

  1. NikoTrend1

    NikoTrend1 Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    How can I add subpartitions in template.
    SET SUBPARTITION TEMPLATE and copy all subpartitions + new subpartitions?
    Or better variant?
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin002.htm

    http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin002.htm#i1007904


    If you have a table only with partitions, then to divide partitions into subparttion it is possible to use:
    1) off-line method:
    to create to table with partition , subpartitions.
    to copy data from the old table.
    to check result.
    if it is necessary, then to create indexes.
    drop old table...

    2) on-line method: dbms_redefiinition
     
    NikoTrend1 likes this.