Unable to NOT include the [ ,Method_Opt => 'FOR ALL COLUMNS SIZE 1 '] line in the script in Toad 10.5.1 and 10.6.1. Toad 9.7.2 does not experience this problem.
I do not want to not include the [ ,Method_Opt => 'FOR ALL COLUMNS SIZE 1 '] line in the script.
In Toad 9.7, I simply check or uncheck the "Collect Histograms with Tables" box (in the “Analyze All Objects” screen) to include or not include the said line in the script.
Steps to reproduce problem:
Go to Schema Browser | right-click a Table | Analyze Table | Options Tab | click “Use DBMS_STATS” | go to Tables Tab (in the same “Analyze All Objects” screen) | click the Green button | then click the Red button | this will generate a script and copied to the Clipboard | Paste it in Notepad or Editor.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle.
