Post reply

You will not be able to switch out or switch in data in this table since the table has non storage aligned indexes on it.

  • April 19, 2013 at 11:19 am

    #394635

    html,body{padding:0;margin:0;font-family:Verdana,Geneva,sans-serif;background:#fff;}html{font-size:100%}body{font-size:.75em;line-height:1.5;padding-top:1px;margin-top:-1px;}h1{font-size:2em;margin:.67em 0}h2{font-size:1.5em}h3{font-size:1.16em}h4{font-size:1em}h5{font-size:.83em}h6{font-size:.7em}p{margin:0 0 1em;padding:0 .2em}.t-marker{display:none;}.t-paste-container{position:absolute;left:-10000px;width:1px;height:1px;overflow:hidden}ul,ol{padding-left:2.5em}a{color:#00a}code, pre{font-size:1.23em}

    Hi,

    I did partitioning on a table on date column as

    FILEGROUP= APPLE

    .ndf FILES= APPLE_2010, APPLE_2011, APPLE_2012, APPLE_2013

    now i am trying to implement sliding window partitioning with partitioning wizard

    when i tried opening manage partition i was not able to select the option for sliding window

    You will not be able to switch out or switch in data in this table since the table has non storage aligned indexes on it.

    can you please help me in making sliding window partitioning

    Thank all

  • April 19, 2013 at 11:26 am

    #1608338

    Sqlism (4/19/2013)

    html,body{padding:0;margin:0;font-family:Verdana,Geneva,sans-serif;background:#fff;}html{font-size:100%}body{font-size:.75em;line-height:1.5;padding-top:1px;margin-top:-1px;}h1{font-size:2em;margin:.67em 0}h2{font-size:1.5em}h3{font-size:1.16em}h4{font-size:1em}h5{font-size:.83em}h6{font-size:.7em}p{margin:0 0 1em;padding:0 .2em}.t-marker{display:none;}.t-paste-container{position:absolute;left:-10000px;width:1px;height:1px;overflow:hidden}ul,ol{padding-left:2.5em}a{color:#00a}code, pre{font-size:1.23em}

    Hi,

    I did partitioning on a table on date column as

    FILEGROUP= APPLE

    .ndf FILES= APPLE_2010, APPLE_2011, APPLE_2012, APPLE_2013

    now i am trying to implement sliding window partitioning with partitioning wizard

    when i tried opening manage partition i was not able to select the option for sliding window

    You will not be able to switch out or switch in data in this table since the table has non storage aligned indexes on it.

    can you please help me in making sliding window partitioning

    Thank all

    The error message is telling you what the problem is: non storage aligned indexes on it.

    You have indexes that are not aligned to your partitions. Look at how your table is partitioned and then look at the indexes defined on the table.

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

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