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 14:49:09 -0400
Message-ID: <CAGYrQyuF3cst_0zTEz-MdgQ4BaMEG67Z=rjNe-MSAjKXV06MTw_at_mail.gmail.com>



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 - 19:49:09 CET

Original text of this message