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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
