: 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
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
, 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
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
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;
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
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
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