12.1 ORA-04023 - Not Fun
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 19 Jun 2017 16:16:13 -0500
Message-ID: <CAP79kiRNHF_paNsMVW=5xhQ+sOVvGZDD8ke=M-VCRABk-1cFMg_at_mail.gmail.com>
12.1.0.2 on Linux:
Date: Mon, 19 Jun 2017 16:16:13 -0500
Message-ID: <CAP79kiRNHF_paNsMVW=5xhQ+sOVvGZDD8ke=M-VCRABk-1cFMg_at_mail.gmail.com>
12.1.0.2 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-lReceived on Mon Jun 19 2017 - 23:16:13 CEST