| FND_STATS.GATHER_SCHEMA_STATISTICS [message #65597] |
Thu, 04 November 2004 02:20  |
Leonie
Messages: 9
Registered: November 2004
|
Junior Member |
|
|
I am trying to use the standard Oracle procedure
FND_STATS.GATHER_SCHEMA_STATISTICS on our Warehouse instance.
When I run the code in SQLPlus logged in as APPS user, it works fine and
gathers the statistics for the ENI schema tables;
exec APPS.FND_STATS.GATHER_SCHEMA_STATISTICS('eni',10,null,'NOBACKUP',null)
But when I run this code logged in as OWBRUN user (which is what I need to run
it as)
in SQLPlus or if I setup a custom Concurrent Program to run it
I get the following error;
SQL> exec
APPS.FND_STATS.GATHER_SCHEMA_STATISTICS('eni',10,null,'NOBACKUP',null)
BEGIN APPS.FND_STATS.GATHER_SCHEMA_STATISTICS('eni',10,null,'NOBACKUP',null);
END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_STATS", line 425
ORA-06512: at "APPS.FND_STATS", line 386
ORA-06512: at line 1
I have granted OWBRUN execute privelege on APPS.FND_STATS and SYS.DBMS_STATS
as I can see it uses this.
What am I missing??
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
