Moving a Table to Another Device

You can also use segments to move a table from one device to another using the create clustered index command.

Clustered indexes, where the bottom or leaf level of the index contains the actual data, are on the same segment as the table. Therefore, you can completely move a table by dropping its clustered index (if one exists), and creating or re-creating a clustered index on the desired segment.