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.