Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbms_stats

dbms_stats

From: Wayne March <wmarch_at_cfl.rr.com>
Date: 19 Aug 2004 11:45:45 -0700
Message-ID: <69e9fe8c.0408191045.5c13cfb0@posting.google.com>


I try to execute dbms_stats.gather_schema_stats (ownname => 'SYSADM'

, degree => 12
, percent_estimate => 30
, cascade => true) ;
and I am getting
dbms_stats.gather_schema_stats (ownname => 'SYSADM'

                                        *
ERROR at line 1:
ORA-00900: invalid SQL statement

Any ideas how do i fix this situation Received on Thu Aug 19 2004 - 13:45:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US