Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automate analyze - can't log in

Re: Automate analyze - can't log in

From: David Sharples <davidsharples_at_gmail.com>
Date: Mon, 29 Aug 2005 16:56:58 +0100
Message-ID: <be592d5505082908566ff8046b@mail.gmail.com> 





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_at_hotmail.com> 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.


--
http://www.freelists.org/webpage/oracle-l


Received on Mon Aug 29 2005 - 10:59:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US