RE: ORA-04098 Problem - Any Ideas??

Hi Eva,

possibilities is you don't have drop index previllege.

Rgrds,

Sony

> -----Original Message-----
> From: Denham Eva [SMTP:EvaD_at_TFMC.co.za]
> Sent: Thursday, January 30, 2003 1:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-04098 Problem - Any Ideas??
>
> Hello List,
>
> I get this error when trying to drop and index, this as the schema owner.
>
> ERROR at line 1:
> ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed
> re-validation
>
> The system is Oracle 817 on Win2000
>
> Does anyone know how to fix this?
> Funny enough the command ALTER INDEX indexname REBUILD; works fine???
>
> TIA
> Regards
> Denham Eva
> Oracle DBA
> "UNIX is basically a simple operating system, but you have to be a genius
> to understand the simplicity."
> Dennis Ritchie.
>
> _____
>
> DISCLAIMER
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
> the sender. You must not, directly or indirectly, use, disclose,
> distribute, print, or copy any part of this message if you are not the
> intended recipient. TFMC, its holding company, and any of its subsidiaries
> each reserve the right to monitor and manage all e-mail communications
> through its networks.
>
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be views of any such entity.
> _____
>
>
> _____
>
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal - For more information please visit www.marshalsoftware.com
> <http://www.marshalsoftware.com>
> _____
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: Sony_at_polyfincanggih.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).