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