RE: Setting tablespace size thresholds for Generate Schema Script

Hi Wayne,

  I'm glad to hear that you are using this.  This is one of those features that sometimes makes me wonder if it's helpful or just unnecessarily complicates things.

  Anyway, to answer your question - Go to the "Script Options" tab first.  Select "Objects with Storage" first and make sure that the "Storage Clauses" checkbox is checked.  If it is, you'll see a "Storage Clause Options" tab in the top row of tabs.  It has the same settings as the "Storage Clause Adjustments" in Rebuild Multiple Objects.

-John


From: [email protected] [mailto:[email protected]] On Behalf Of kergegeek
Sent: Thursday, March 29, 2012 11:32 AM
To: [email protected]
Subject: [toad] Setting tablespace size thresholds for Generate Schema Script



Where do I set the thresholds for Small, Medium, Large, Huge tables/tablespaces for the Generate Schema Script functionality?

The Storage Clause Options tab has only one sub-tab, Tablespaces, and that only has the options for specifying which named tablespaces the different categories map to.

I know that in the Rebuild Multiple Objects window, the Storage Clause Adjustments tab has the Extents sub-tab (in addition to the Tablespaces sub-tab) that allows you to define the thresholds for rebuilds, but that does not seem to apply to the Generate Schema functionality.

I'm on TOAD 10.6.1.3.

Thanks

Wayne