CREATE SYNONYM

How to Resolve ORA-00995: missing or invalid synonym identifier

by Ed Chen
July 22, 2022October 1, 2022

ORA-00995 ORA-00995 means that the synonym name you specified in the statement is either invalid or not found, you should make sure the synonym identifier… 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 »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020June 6, 2023
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Resolve ORA-00955: name is already used by an existing object

by Ed Chen
November 30, 2019March 30, 2023

ORA-00955 ORA-00955 means that the name of the schema object that you tried to create is already used and taken by some other existing schema… Read More »

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