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

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 24 Mar 2015 17:09:21 +0700
Message-ID: <CAP50yQ8FL35pYho4cS5tXZrw_VptqB760ds8n7ULCwFdGKB+wA_at_mail.gmail.com>

Have you tried to enable 10046 trace and check where exactly the error is raised ? It may shed some light on what happens underneath the covers.

Stefan

On Tue, Mar 24, 2015 at 4:08 AM, Juan Carlos Reyes Pacheco < jcdrpllist_at_gmail.com> wrote:

> 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 Tue Mar 24 2015 - 11:09:21 CET