This tip comes from Robert Ware – This script generates DDL to modify the default tablespace name for partitioned indexes. However, it could be easily modified to alter other segment types as well.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help