RE: Error when running dbms_stats

This is oracle 10.2.0.1 on RHAT4, I almost isolated the issue and will open support request. Problem is we recently added a login trigger for hs user to set some nls settings and from that onwards I am not able to do export using hs login but I was able to do the export for HS schema using system user. I can't drop the user currently since database is in use but as soon as I get chance will try to drop login trigger and see if this works again or not.

Thanks
--Harvinder

-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com] Sent: Wednesday, January 31, 2007 8:29 PM To: Harvinder Singh
Cc: oracle-l
Subject: Re: Error when running dbms_stats

Did you recently upgrade to 9.2.0.8?
There was an almost identical post just recently.

At 04:04 PM 1/31/2007, oracle-l-bounce_at_freelists.org wrote:
>Hi,
>
>I am running the following script and getting errors:
>begin
>dbms_stats.gather_schema_stats(ownname=> 'HS',estimate_percent=>
>100,degree=> dbms_stats.auto_degree,granularity=> 'AUTO',method_opt=>
>'FOR ALL COLUMNS SIZE AUTO',options=> 'GATHER',cascade=> TRUE);
>end;

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l