Fwd: trying to drop user

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Tue, 14 Jan 2014 10:24:41 -0400
Message-ID: <CAGYrQyu6ZnBCthb2fyoMuuJbrhQS+buBVHd7i-5_FmMhSRpN3w_at_mail.gmail.com>

Hi
Did you tried to startup upgrade your database and execute a drop user cascade? sometimes help.

2014/1/14 Zelli, Brian <Brian.Zelli_at_roswellpark.org>

  I am trying to drop the user mdsys and get the following error:
>
>
>
> *
>
> ERROR at line 1:
>
> ORA-04098: trigger 'MDSYS.SDO_TOPO_DROP_FTBL' is invalid and failed
>
> re-validation
>
>
>
> How do I get rid of this user?
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 14 2014 - 15:24:41 CET