RE: strange error on DBMS_STATS

2002-12-19 Thread Rachel Carmichael
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

RE: strange error on DBMS_STATS

2002-12-19 Thread Jamadagni, Rajendra
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

Re: strange error on DBMS_STATS

2002-12-19 Thread Tim Gorman
...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

RE: strange error on DBMS_STATS

2002-12-19 Thread Jesse, Rich
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

Re: strange error on DBMS_STATS

2002-12-19 Thread Rachel Carmichael
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

Re: strange error on DBMS_STATS

2002-12-19 Thread Stephane Faroult
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.

Re: strange error on DBMS_STATS

2002-12-19 Thread Rachel Carmichael
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:

RE: strange error on DBMS_STATS

2002-12-19 Thread Godlewski, Melissa
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

RE: strange error on DBMS_STATS

2002-12-19 Thread Rachel Carmichael
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)