Home » RDBMS Server » Server Administration » Error while executing Dbms_Stats.GATHER_TABLE_STATS
Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226694] Mon, 26 March 2007 04:01 Go to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

Hi ,

I am compiling this procedure for gathering table statistics and getting following err :-

CREATE OR REPLACE PROCEDURE TAB_ANALYZE AS
BEGIN
EXECUTE Dbms_Stats.GATHER_TABLE_STATS (ownname=>'RDM',tabname=>'DM_FACT_MOS',estimate_percent=>10,method_opt=>'FOR ALL INDEXED COLUMNS',DEGREE=>6,granularity=>'ALL');
END;


------------------
PLS-00103: Encountered the symbol "DBMS_STATS" when expecting one of the following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "DBMS_STATS" to continue.
----------------
Any help in this issu.....


Asif
Re: Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226696 is a reply to message #226694] Mon, 26 March 2007 04:05 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Remove Execute


dwadm@DW.US.ORACLE.COM> CREATE OR REPLACE PROCEDURE TAB_ANALYZE AS
  2  BEGIN
  3   Dbms_Stats.GATHER_TABLE_STATS (ownname=>'RDM',tabname=>'DM_FACT_MOS',estimate_percent=>10,meth
od_opt=>'FOR ALL INDEXED COLUMNS',DEGREE=>6,granularity=>'ALL');
  4  END;
  5  /

Procedure created.
Re: Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226700 is a reply to message #226694] Mon, 26 March 2007 04:19 Go to previous message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

awesome solution man,

i was stucked on it from the morning but did not got any solution....

Thanks a lot
Asif
Previous Topic: Problem with AQ sys packages while upgrading from oracle 9i to oracle 10g
Next Topic: Datapump Error
Goto Forum:
  


Current Time: Thu Dec 08 10:36:48 CST 2016

Total time taken to generate the page: 0.17540 seconds