  | | | ORA-2000 Error Using DBMS_STATS.GATHER_SCHEMA_STATS | ORA-2000 Error Using DBMS_STATS.GATHER_SCHEMA_STATS 2004-02-18 - By Freeman, Donald
Back This thing just popped up yesterday. I'm using Oracle 9i Rel 2 Ver. 9.2.0.4 on Windows 2000 Advanced Server This code has been running inside a package for some time and I've never seen a failure.
The following is failing.
DBMS_STATS.GATHER_SCHEMA_STATS ( OWNNAME=>'PADOHSNAP', CASCADE=>TRUE );
It fails the same place each time on the same table.VACCINE_TYPE_CODE which is a materialized view. The view is valid.
The job is running under sys user. The above code cannot be run by the owner either. The table, individually, can be analyzed by either the owner or the user. The synonym is valid. What am I missing? As far as I can tell no one changed anything yesterday but obviously something changed.
Don Freeman Database Administrator Bureau of Information Technology PA Department of Health 717-783-4743 Ext 337
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ Please see the official ORACLE-L FAQ: http://www.orafaq.com -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ To unsubscribe send email to: oracle-l-request@(protected) put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
 |