oracle rename synonym

oracle rename synonym

                 

 oracle rename renames ANY private synonym.

 

Synonyms can be created to table,view,sequence,procedure,function,package,materialized view,java class schema,user-defined object type or another synonym.

 

SYNTAX:

Rename <old Name> to <new name>;

Create synonym for scott.emp table;

 SQL> Create synonym emp for scott.emp;

 
renames emp synonym  to employees;

 

SQL>rename emp to employees;

 

SQL> select * from employees;

Tags:  rename SYNONYM    in oracle,oracle rename SYNONYM   , oracle rename syntax, oracle rename cons,oracle rename pros, How to rename SYNONYM    in oracle,rename SYNONYM    affect on triggers,rename private synonym in oracle.