Oracle-L: DBMS

From: Scott Bunnett <sbunnett_at_researchplus.com.au>
Date: Tue, 02 Apr 2002 15:53:24 -0800
Message-ID: <F001.00439645.20020402155324@fatcity.com>

Hi,

I am new to using oracle and was wondering if anyone could help me out in using the DBMS_STAT's package. Firstly, does the package need to be installed as I am trying to run some of the subprograms but get errors like:

execute DBMS_STATS.GATHER_TABLE_STATS( ownname=>'SCOTT', tabname=>'user_backup', cascade=>TRUE);
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'SCOTT', tabname=>'user_backup', cascade=>TRUE); END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body "SYSTEM.DBMS_STATS" does not exist
ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1

Secondly, if I don't specifiy a 'stattab', the statistics are stored in the dictionary. Where and what is this.
Sorry for the low level question, but I need to start somewhere..

Thanks
Scott

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Scott Bunnett
INET: sbunnett_at_researchplus.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 02 2002 - 17:53:24 CST