Results 1 to 3 of 3

Thread: dbms_stats

  1. #1
    Join Date
    Jan 2004
    Posts
    84

    Unanswered: dbms_stats

    Am running this as sys user but still getting error.

    SQL> exec dbms_stats.dbms_stats_gather_table_stats(ownname=> 'MIS',tabname=>'BA_EXPENSES',cascade=>TRUE);
    BEGIN dbms_stats.dbms_stats_gather_table_stats(ownname=> 'MIS',tabname=>'BA_EXPENSES',cascade=>TRUE); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 18:
    PLS-00302: component 'DBMS_STATS_GATHER_TABLE_STATS' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

  2. #2
    Join Date
    Nov 2003
    Posts
    19
    The command is
    dbms_stats.gather_table_stats

  3. #3
    Join Date
    Jan 2004
    Posts
    84
    Thank You!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •