How to generate image copy and Runstas of all tablespaces at the database level? (4241142)

How to generate image copy and Runstas of all tablespaces at the database level?

Would like to know if Toad can generate utility commands at the database level. For example, how to generate image copy of all tablespaces in a database? Likewise, generate Runstats of all tablespaces in a database (instead of doing individually one tablespace at a time).

Please follow the steps below:

1.  Image copy of tablespaces in database, you can get the ddl script to create the tablespaces by doing the following:

-  In the Database Explorer window go to the Tablespaces tab, use Shift + click to select all the tablespaces you want.  Then right click and select Extract DDL.

2.   For the Runstats

-  In the Database Explorer window go to the Tablespaces tab, use Shift + click to select all the tablespaces you want.  Then right click and select Utilities | RunStats.

You can get the script or Execute from here.