General Restrictions for the ATTACH Clause

This clause is not valid in ALTER FRAGMENT ON INDEX statements.

Any tables that you attach must have been created previously in separate partitions. You cannot attach the same table more than once.

All consumed tables listed in the ATTACH clause must have the same structure as the surviving table. The number, names, data types, and relative position of the columns must be identical.

The expression cannot include aggregates, subqueries, or variant functions.

Additional Restrictions on the ATTACH Clause in Dynamic Server

User-defined routines and references to fields of a ROW-type column are not valid. You cannot attach a fragmented table to another fragmented table.

All of the dbspaces that store the fragments must have the same page size.

Additional Restrictions on the ATTACH Clause in XPS

In addition to the general restrictions, every consumed table must be of the same usage type as the surviving table. For information about how to specify the usage type of a table, refer to Logging Options.

The ATTACH clause is not valid under either of the following conditions:

• If the consumed tables contain data that belongs in some existing fragment of the surviving table
• If existing data in the surviving table would belong in a new fragment

Thus, you cannot use the ATTACH clause for data movement among fragments. To perform this task, see the INIT Clause.