Re: 12.1 ORA-04023 - Not Fun

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_at_fnni.com> wrote:

> I’ve had luck just doing a describe or selecting from the public synonyms
> to get them validated.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.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
>

--
http://www.freelists.org/webpage/oracle-l