Oracle Create synonyms

First, you need to create a synonym permission for the user:

Sql> Grant create synonym to Jhchen;

Grant succeeded.

To create a synonym syntax:

Create synonym name for owner. Object name

Need to login with Jhchen

sql> create synonym eos_kpi_usersalary for kpi.eos_kpi_usersalary;

Synonym created

Batch change synonyms need to be queried by the owner first:

SELECT ' create synonym ' | | object_name | | ' for KPI. ' | | object_name | | ‘;‘

From User_objects

WHERE object_type in

(' TABLE ', ' VIEW ', ' PROCEDURE ', ' TRIGGER ', ' FUNCTION ', ' package ');

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6D/68/wKioL1Vj5iiCrwyFAARF6Gwf2FE488.jpg "title=" Qq20150526111410.png "alt=" wkiol1vj5iicrwyfaarf6gwf2fe488.jpg "/> Copy the following statement executed under Jhchen user!

This article is from "one van" blog, please be sure to keep this source http://1336014.blog.51cto.com/1326014/1655185

Oracle Create synonyms