RE: Error when running dbms_stats
- To: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>, "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
- Date: Fri, 2 Feb 2007 11:46:17 -0500
FYI
----
I just confirmed with Oracle and this is a bug in 10.2.
"
This is due to Bug# 3945156.
- Bug# 3945156.
Abstract: ORA-979 DOING DBMS.GATHER_TABLE_STATS WHEN NLS_COMP=LINGUISTIC
AND
Details:
NLS_SORT is set to a non BINARY value.
When gathering histogram statistics via dbms_stats and when NLS_LANG is
set
to GERMAN_GERMANY.WE8MSWIN1252 amd NLS_COMP is set to LINGUISTIC, the
gathering function will cause ora-979 error:"
-----Original Message-----
From: Harvinder Singh
Sent: Thursday, February 01, 2007 10:23 AM
To: 'Wolfgang Breitling'
Cc: oracle-l
Subject: 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@xxxxxxxxxxxxx]
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@xxxxxxxxxxxxx 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
