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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center