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: Fri, 13 Mar 2015 17:31:41 -0400
Message-ID: <CAGYrQysTGFz-Es5VdawP0OAGPPFDtm+Fp2VhZN1Q7yHMmRhaUQ_at_mail.gmail.com>

Thank you Andrew, I'll try next time. :) We had corruption in idl_ub1$, so we rebuild it, following a procedure we found.

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 Fri Mar 13 2015 - 22:31:41 CET