Oracle creates synonyms
First, you need to create synonym permissions for the user:
SQL > grant create synonym to jhchen
Grant succeeded.
Create synonym syntax:
Create synonym name for owner. Object name
Need to log in with jhchen
SQL > create synonym eos_kpi_usersalary for kpi.eos_kpi_usersalary
Synonym created
To change synonyms in bulk, you need to query 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')
Copy the following statement and execute it under the jhchen user!
