Error 4953

Severity

16

Message text

Cannot partition table '%.*s' because it is already partitioned.

Explanation

The partition clause of the alter table command allows you to partition user tables that do not have a clustered index. You cannot partition a table that is already partitioned.

Error 4953 occurs when you try to partition a table that is already partitioned.

Action

To change the number of partitions for the table, follow these steps:

  1. Concatenate all existing page chains:

    1> use <database_name>
    2> go
    
    1> alter table <table_name> unpartition
    2> go
    
  2. Repartition the table:

    1> alter table <table_name> partition
    2> <number_of_partitions>
    3> go
    

Additional information

Refer to the Reference Manual: Commands for information about the alter table command.

Versions in which this error is raised

All versions