OraFAQ Forum: Server Administration » Error while executing Dbms_Stats.GATHER_TABLE

Home » RDBMS Server » Server Administration » Error while executing Dbms_Stats.GATHER_TABLE_STATS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226694]

Mon, 26 March 2007 04:01

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

Report message to a moderator

Re: Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226696 is a reply to message #226694]

Mon, 26 March 2007 04:05

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.

Report message to a moderator

Re: Error while executing Dbms_Stats.GATHER_TABLE_STATS [message #226700 is a reply to message #226694]

Mon, 26 March 2007 04:19

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

Report message to a moderator

Previous Topic:	Problem with AQ sys packages while upgrading from oracle 9i to oracle 10g
Next Topic:	Datapump Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 11:19:38 CST 2024