Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_STATS....invalid SQL statement

620697Mar 26 2008 — edited Mar 26 2008
Hi,

I am trying to execute below statement but got the error:

exec dbms_stats.gather_schema_stats(
ownname => 'nascto',
estimate_percent => dbms_stats.AUTO_SAMPLE_SIZE,
method_opt => 'for all columns size auto',
degree => 7,
options => 'GATHER AUTO')

ORA-00900: invalid SQL statement
The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed

When I checked this below query: it is showing banner for PL/SQL

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production

TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

I am puzzled ,now what to do ?
Does anybody have any idea,Please let me know.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2008
Added on Mar 26 2008
3 comments
2,046 views