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@xxxxxx>: > 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Juan Carlos Reyes Pacheco > *Sent:* Monday, March 23, 2015 2:49 PM > *To:* Andrew Kerber > *Cc:* dmarc-noreply@xxxxxxxxxxxxx; 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@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.' > > >