Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.
— Create a Public Synonym for a Table —
CREATE OR REPLACE PUBLIC SYNONYM EASYNAME for EASYORADBA.TABLE00001 ;
— Drop a Public Synonym for a Table —
DROP PUBLIC SYNONYM EASYNAME ;
— View to Check Synonyms in Oracle —
SELECT * from DBA_SYNONYMS;
