Hi,
I've 2 schemas namely department , hr
Now department schema is having one table EMP . And a view is created on that table with the name R_EMP
Schema Name : department
Table Name : EMP
View Name : R_EMP
GRANT SELECT ON R_EMP TO HR ;
In HR schema a synonym has been created on view R_EMP with the name R_EMP .
CREATE OR REPLACE SYNONYM hr.R_EMP for department.R_EMP
Schema Name : hr
Synonym Name: R_EMP
Now I want to rename the view name R_EMP to V_EMP from HR schema only
So, I tried the folloiwng syntax in HR schema (All the operations should be done from this schema only )
[code]
RENAME department.R_EMP to department.V_EMP ;
Error:
ORA-01765: specifying table's owner name is not allowed
[/code]
How to change the syntax to make the statement work from HR schema .
Thank You .