Post reply

Partition on existing partitioned tables!!!

  • April 19, 2011 at 1:31 pm

    #249563

    Hi,

    I have several partitioned tables.Tables are partitioned by monthly for 13 months.But now I have requirement to reconfigure the existing partitions from 13 months to 36.

    I know how to created partition but not sure what process do I have to follow right from start to reconfiguration on existing partioned tables.

    Please advice me what steps do I need to do this.

    Any advise will be appreciated.

    Thanks in advance!

    Stad.

  • April 19, 2011 at 3:07 pm

    #1313656

    You can either issue a series of ALTER PARTITION FUNCTION statements to create the additional partitions or you create a new table with the partitioning you want and then INSERT the data into the new table, drop the old table and rename the new one to the existing tables name.

    http://technet.microsoft.com/en-us/library/ms186307.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 20, 2011 at 7:37 am

    #1313939

    Thank You Opc.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply