The name of that object suggests to me that it's a java class intended for
use integrating AQ with Java Messaging System (jms).
I'd start with utl_recomp, and then look at an SR with the AQ team.
On 19 Jun 2017 23:15, "Chris Taylor" <christopherdtaylor1994@xxxxxxxxx>
wrote:
I'm not sure - how do I tell?
If I try to describe the underlying sys object "/7e7bb219_AQjmsReflectAQjmsThr"
I get
SP2-0749: Cannot resolve circular path of synonym "sys."/7e7bb219_
AQjmsReflectAQjmsThr""
So, maybe historical reasons?
On Mon, Jun 19, 2017 at 4:51 PM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:
Are the objects real SYS objects, or are they created in the SYS schema
for historical reasons?
On Mon, Jun 19, 2017 at 10:26 PM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
Well, I went ahead and did a "create or replace public synonym..." and
one of them resolved, but the other is still showing a mismatch.
Annoying.
Chris
On Mon, Jun 19, 2017 at 4:23 PM, Givens, Steven <sgivens@xxxxxxxx> wrote:
I’ve had luck just doing a describe or selecting from the public
synonyms to get them validated.
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@freeli
sts.org] *On Behalf Of *Chris Taylor
*Sent:* Monday, June 19, 2017 4:16 PM
*To:* ORACLE-L
*Subject:* [External] 12.1 ORA-04023 - Not Fun
12.1.0.2
<https://urldefense.proofpoint.com/v2/url?u=http-3A__12.1.0.2&d=DwQFaQ&c=LkAXfnqL6_MvrMPL5JzdE3Ild0DUTpmjbCJvMv5_TcQ&r=p64P693r52tzs7tJCmFvOg&m=F9S541MtQ8HyADmSNyHC9Bq2XAAme-EExkx0GB1pFBI&s=5iKEXBzbqbgVF3KbhH7EYCOBXUxgpjIKUEneFlb38Y0&e=>
on Linux:
select * from < table_name > ;
ORA-04023: Object select * from <owner>.<table_name> could not be
validated or authorized
Metalink Note: 1610514.1 (Regarding Views) says its a timestamp issue in
the data dictionary.
The only results returned from the query (provided by support) are 2 SYS
public synonyms.
What is the "best" way to fix SYS public synonyms?? Can you recompile
public synonyms? I was thinking they had to be dropped and re-created.
Suggestions?
Chris
--
Niall Litchfield
Oracle DBA
http://www.orawin.info