Assigning Database Objects to Segments

Assign new or existing database objects to user-defined segments to restrict new objects
to one or more devices, place a table and its index on separate devices, or split an existing
object over multiple devices.

Placing Existing Objects on Segments
sp_placeobject does not remove an object from its allocated segment. However, it causes all further disk allocation for that object to occur on the new segment it specifies.