this is being run in sqlplus as
execute dbms_stats.gather_schema_stats
If I didn't run it (on another schema) within the same sql script, I'd
think it was that I didn't have privs on dbms_stats.
I'll keep looking
--- Jesse, Rich [EMAIL PROTECTED] wrote:
Yes, but it turned out to be privs
Title: RE: strange error on DBMS_STATS
Probably wrong question ... but was rebuilt index still owned by schema owner?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
...I've got this hammer called SQL Trace and just about
every problem looks like a nail...
Good thing is, this'll probably resolve it for you. Can you
run this in the same session prior to running the
GATHER_SCHEMA_STATS?
alter session set max_dump_file_size = unlimited;
alter session set
Yes, but it turned out to be privs (or lack thereof) to run the stats or
associated queries in a procedure, rather than privs to do the analyze
itself. Do you have auditing turned on? That's usually the first place I
check to see what objects changed since the last time it worked.
GL!
Rich
I love the hammer. The problem is, this is the production database, I'm
the development DBA. Until there are production problems. I have no
access to the system, and I have no access to the routine that runs
dbms_stats. Other than that, I can do anything :)
I'll see if I can get this inserted
Rachel Carmichael wrote:
We are not changing passwords, so I am presuming that this involves
(somehow) a change of username. According to the package header, it
will throw an ORA-2 if there are insufficent privileges. We rebuilt
an index yesterday but did NOT change or add any table.
you and Raj had the same thought. but no, the index is owned by the
table owner
got access so I could run the gather with a 10046 trace. so of course
it's not failing as yet. sigh. and my boss wonders why I talk to myself
--- Stephane Faroult [EMAIL PROTECTED] wrote:
Rachel Carmichael wrote:
Title: RE: strange error on DBMS_STATS
I thought people talked to themselves so they could get all the right answers.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 3:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Re
believe me, I'm talking to the wrong person if I want to get the right
answers.
Okay, we fixed it but I'm not sure why it happened. I re-granted
s/i/u/d on all the tables owned by the schema_owner directly to the
user running the gather_stats
it's running properly.
Reconstruction of events:
1)