Re: recompile causes an ORA-21700: object does not exist or is marked for delete
- From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Mon, 23 Mar 2015 14:49:09 -0400
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@xxxxxxxxx>:
> 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@xxxxxxxxxxxxx> 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
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
Other related posts:
