ALL_SYNONYMS

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022May 12, 2023

ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… Read More »

How to Resolve ORA-00980: synonym translation is no longer valid

by Ed Chen
September 15, 2021May 29, 2023

ORA-00980 We usually use synonyms to point to a base object that we don't own it. Let's see a case. SQL> conn oe/oe@orclpdb1 Connected. SQL>… Read More »

Get DDL from ALL_SYNONYMS

by Ed Chen
July 31, 2021April 11, 2023

You don't have to export and import public synonyms by data pump, you can compose the creation statements by querying ALL_SYNONYMS:: [oracle@primary01 oracle]$ vi compose_create_or_replace_synonym.sql… Read More »

JavaScript is not enabled. Please enable it and reload the page.