RE: recompile causes an ORA-21700: object does not exist or is marked for delete
Date: Mon, 23 Mar 2015 19:37:00 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD127931EB6_at_G4W3290.americas.hpqcorp.net>
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<mailto: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<mailto: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 - 20:37:00 CET