1 Reply Latest reply: Mar 5, 2013 12:54 PM by Solomon Yakobson RSS

    How to gather table stats for tables in a different schema

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