DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: query for gathering all the statistics of indexes in a schema

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    11

    query for gathering all the statistics of indexes in a schema

    Kindly guide me for the query for gathering all the statistics of indexes in one schema.
    I have given the following query but it is giving error.
    exec DBMS.STATS.GATHER_INDEX_STATS('name of the index')

    it is giving me error the DBMS.STATS must be declared.
    however when i tried to analyze all my tables of whole schema by similar query.it worked nicely.

    Kindly guide me to suitable solution

    Regards,
    Saurabh

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: query for gathering all the statistics of indexes in a schema

    Originally posted by saurabhvtechno
    DBMS.STATS must be declared.
    DBMS_STATS ( BTW RTM )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Its a typo..

    replace dbms.stats

    with DBMS_STATS


    regards
    Hrishy

Posting Permissions

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


Click Here to Expand Forum to Full Width