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.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help