you are missing a 'as sysdba' as the sys login, 9i has to be sysdba for sys On 8/29/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > The sql script (below) does stats on everything in the database and then > deletes them from sys and system. My boss wanted it that way so that if any > schemas get added, we won't have to worry about forgetting to do stats on > them. -- //www.freelists.org/webpage/oracle-l