4 Replies Latest reply: Nov 23, 2012 11:33 AM by rp0428 RSS

    ORA-20000: TABLE "DATA"."" does not exist or insufficient

    user9256814
      Hi Team,

      I am using the dbms_stats.DIFF_TABLE_STATS_IN_HISTORY package to view old statistics as a owner of the object. I am getting error. i thing this is not realted privilege. Beause i am having role SELECT_CATALOG_ROLE,OEM_ADVISOR and also i am running the below as a owner of the object. Please help me on this.

      select * from table (dbms_stats.DIFF_TABLE_STATS_IN_HISTORY ('DATA','',trunc(sysdate-2)));
      REPORT
      --------------------------------------------------------------------------------
      MAXDIFFPCT
      ----------
      ORA-20000: TABLE "DATA"."" does not exist or insufficient priv

      Thanks.