RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-21 Thread Rajesh Dayal
: Problem with DBMS_UTILITY.ANALYZE_DATABASE grant analyze any to sys; hth connor --- Bachmann, Henrik [EMAIL PROTECTED] wrote: Hi there, I have a problem to analyze my whole database as user sys: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL

Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-21 Thread Bachmann, Henrik
recipients of list ORACLE-L Betreff: RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE Set sql_trace on before running it and see which sys sql fails. Regards, Waleed -Original Message- Sent: Friday, May 18, 2001 10:31 AM To: Multiple recipients of list ORACLE-L

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-21 Thread Hillman, Alex
, 2001 10:31 AM To: Multiple recipients of list ORACLE-L unfortunately no other result with ... grant analyze any -Ursprüngliche Nachricht- Von: Connor McDonald [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 18. Mai 2001 15:36 An: Multiple recipients of list ORACLE-L Betreff: Re: Problem

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-20 Thread C.S.Venkata Subramanian
unfortunately no other result with ... grant analyze any -Ursprüngliche Nachricht- Von: Connor McDonald [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 18. Mai 2001 15:36 An: Multiple recipients of list ORACLE-L Betreff: Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE grant

Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-18 Thread Bachmann, Henrik
Hi there, I have a problem to analyze my whole database as user sys: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SQL BEGIN 2 DBMS_UTILITY.ANALYZE_DATABASE('COMPUTE',NULL,NULL,NULL); 3 END;

Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-18 Thread Connor McDonald
grant analyze any to sys; hth connor --- Bachmann, Henrik [EMAIL PROTECTED] wrote: Hi there, I have a problem to analyze my whole database as user sys: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SQL BEGIN

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-18 Thread Bachmann, Henrik
unfortunately no other result with ... grant analyze any -Ursprüngliche Nachricht- Von: Connor McDonald [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 18. Mai 2001 15:36 An: Multiple recipients of list ORACLE-L Betreff: Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE grant

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-18 Thread Khedr, Waleed
McDonald [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 18. Mai 2001 15:36 An: Multiple recipients of list ORACLE-L Betreff: Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE grant analyze any to sys; hth connor --- Bachmann, Henrik [EMAIL PROTECTED] wrote: Hi there, I have a problem