 | | | 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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|