SQL & PL/SQL

Hi All,

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

DBMS_STATS.GATHER_TABLE_STATS (OWNNAME=>'SCHMEA1',TABNAME=>'T1');

The function is failing.

Is there any way we can gather table stats for tables in one schema in an another schema.

Thanks,
MK.