Toad World® Forums

Toad for Data Analysts, cannot run gather_table_stats in SQL

We are still using Toad for Data Analysts. I hope it is appropriate to post this here.

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, 2.6.1.568, license is good
  • ToadCore Plug In ver 4.6.1.568
  • ToadOracle Plug In ver. 4.6.0.568
  • ToadOracle Provider Plug In ver 4.6.0.568
  • ToadPlugin Plug In ver 4.6.0.568

Does it not execute the statement? Generally parser errors should not stop the execution I don’t think.

It stops executing after producing the error shown.

John

From: Henrik Johnson [mailto:bounce-Henrik_Johnson@toadworld.com]

Sent: Thursday, February 12, 2015 2:26 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Toad for Data Analysts, cannot run gather_table_stats in SQL

RE: Toad for Data Analysts, cannot run gather_table_stats in SQL

Reply by Henrik Johnson

Does it not execute the statement? Generally parser errors should not stop the execution I don’t think.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

Try using the action “Execute Script in External App”. This will execute in a different editor which may understand this syntax better.