Re: recompile causes an ORA-21700: object does not exist or is marked for delete

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Mon, 23 Mar 2015 17:08:42 -0400
Message-ID: <CAGYrQyvtpQrMo8p5FY+GkCLjmFquKiBiCb3LEBoD-YdiSF-Y7w_at_mail.gmail.com>

Thank you Mark, but no, there is the specification and the body, I dropped the body and recreated, and same problem. The problem is in the specification.

It is a mysterious mystery.

2015-03-23 15:37 GMT-04:00 Powell, Mark <mark.powell2_at_hp.com>:

> Andrew, I do not remember the previous entries in the thread but any
> change you have a package body without a specification. I am pretty sure I
> have seen this once or twice. If so, drop the package body only: drop
> package body owner.package_name.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Juan Carlos Reyes Pacheco
> *Sent:* Monday, March 23, 2015 2:49 PM
> *To:* Andrew Kerber
> *Cc:* dmarc-noreply_at_freelists.org; ORACLE-L
> *Subject:* Re: recompile causes an ORA-21700: object does not exist or is
> marked for delete
>
>
>
> Hello Andrew, I reproduced the error and don't work.
> ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE SCOPE=SPFILE; and restarted
>
>
> and
>
>
> startup upgrade, because in theory has a similar effect.
>
>
>
>
> SQL> ALTER PACKAGE FON.PCK_REP_FORMULARIOS_UIF COMPILE;
> ALTER PACKAGE FON.PCK_REP_FORMULARIOS_UIF COMPILE
> *
> ERROR at line 1:
> ORA-21700: object does not exist or is marked for delete
>
> I'm going to move data to a empty database anyway.
>
>
>
>
>
> 2015-03-13 14:12 GMT-04:00 Andrew Kerber <andrew.kerber_at_gmail.com>:
>
> This is pretty much a wild shot in the dark because you provide us very
> little information. But did you try setting _system_trigs_enabled to false?
>
>
>
> On Fri, Mar 13, 2015 at 1:04 PM, Mladen Gogala <
> dmarc-noreply_at_freelists.org> wrote:
>
> On 03/13/2015 12:24 PM, Juan Carlos Reyes Pacheco wrote:
>
> Hello, please do you know some solution to this problem
> This is not the first time, a database become corrupted previously only
> for this.
>
> I tried to reconnect, restart, etc.
>
> Do you know some trick or procedure?
>
> Thank you :)
>
> That depends on what are you doing. With this much information, I can only
> suggest prayer based solutions.
>
> --
> Mladen Gogala
> Oracle DBA
> http://mgogala.freehostia.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>

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

Received on Mon Mar 23 2015 - 22:08:42 CET