Re: Automate analyze - can't log in

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Mon, 29 Aug 2005 16:56:58 +0100

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

Other related posts: