Toad World® Forums

Toad for Data Analysts used with Oracle, can't run gather statistics

I am connected to an Oracle database, user=WFPDMHM, schema=WFPDMHM. I am running this command

exec dbms_stats.gather_table_stats(ownname=>‘WFPDMHM’,tabname=>‘hpt_cmpn_exclude_rsn_hist’,estimate_percent=>‘10’,CASCADE=>TRUE,DEGREE=>8);

It returns this error:

Category Timestamp Duration Message Line Position Parser Messages 2/12/2015 10:26:56 AM line 29, col 1: Incorrect syntax near ‘dbms_stats’

Running the exact same command in Oracle SQL Developer 3.2.9 works just fine.

Explanations and suggestions will be greatly appreciated, but upgrading is not a viable option.

  • Toad for Data Analysts,, license is good
  • ToadCore Plug In ver
  • ToadOracle Plug In ver.
  • ToadOracle Provider Plug In ver
  • ToadPlugin Plug In ver

You’re in the Toad for Oracle forum, not TDA, but I’ll take a stab at the answer anyway…

try it like this instead:


dbms_stats.gather_table_stats (ownname=>‘WFPDMHM’,tabname=>‘hpt_cmpn_exclude_rsn_hist’,estimate_percent=>‘10’,CASCADE=>TRUE,DEGREE=>8);


Thanks for the quick reply. I’m posting in this forum thinking it might be more of an Oracle issue.

This Toad for Data Analysts I’m using (renamed a few years ago as Toad Data Point) can’t run PL/SQL constructs like begin–end in the SQL editor window. That would certainly simplify my life.