Upto my knowledge, u can't analyse sys objects.
HTH
--
On Fri, 18 May 2001 08:17:08
Khedr, Waleed wrote:
>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
>
>
>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 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
>> > 2
>> >
>> DBMS_UTILITY.ANALYZE_DATABASE('COMPUTE',NULL,NULL,NULL);
>> > 3 END;
>> > 4 /
>> > BEGIN
>> > *
>> > FEHLER in Zeile 1:
>> > ORA-20000: You have insufficient privileges for an
>> > object in this
>> > database.
>> > ORA-06512: in "SYS.DBMS_UTILITY", Zeile 282
>> > ORA-06512: in Zeile 2
>> >
>> > Anybody out there who can give me a hint?
>> >
>> > Best regards
>> >
>> > Henrik
>> >
>> > Henrik Bachmann
>> > mailto:[EMAIL PROTECTED]
>> >
>> > B.I.M.-Consulting Magdeburg
>> > http://www.bim-consulting.de/
>> > D-39108 Magdeburg
>> >
>> >
>> > --
>> > Please see the official ORACLE-L FAQ:
>> > http://www.orafaq.com
>> > --
>> > Author: Bachmann, Henrik
>> > INET: [EMAIL PROTECTED]
>> >
>> > Fat City Network Services -- (858) 538-5051 FAX:
>> > (858) 538-5051
>> > San Diego, California -- Public Internet
>> > access / Mailing Lists
>> >
>> --------------------------------------------------------------------
>> > To REMOVE yourself from this mailing list, send an
>> > E-Mail message
>> > to: [EMAIL PROTECTED] (note EXACT spelling of
>> > 'ListGuru') and in
>> > the message BODY, include a line containing: UNSUB
>> > ORACLE-L
>> > (or the name of mailing list you want to be removed
>> > from). You may
>> > also send the HELP command for other information
>> > (like subscribing).
>>
>>
>> =====
>> Connor McDonald
>> http://www.oracledba.co.uk (mirrored at
>> http://www.oradba.freeserve.co.uk)
>>
>> "Some days you're the pigeon, some days you're the statue"
>>
>> ____________________________________________________________
>> Do You Yahoo!?
>> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>> or your free @yahoo.ie address at http://mail.yahoo.ie
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: =?iso-8859-1?q?Connor=20McDonald?=
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bachmann, Henrik
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: C.S.Venkata Subramanian
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
