Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
SQL and PL/SQL
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 5, 2013 12:54 PM by
How to gather table stats for tables in a different schema
Mar 5, 2013 12:37 PM
I have a table present in one schema and I want to gather stats for the table in a different schema.
I gave GRANT ALL ON SCHEMA1.T1 TO SCHEMA2;
And when I tried to execute the command to gather stats using
The function is failing.
Is there any way we can gather table stats for tables in one schema in an another schema.
This content has been marked as final.
Show 1 reply
Re: How to gather table stats for tables in a different schema
Mar 5, 2013 12:54 PM
in response to
You need to grant analyze any to schema2.