This discussion is archived
11 Replies Latest reply: Oct 17, 2013 8:38 AM by jgarry RSS

How do I rename table or synonym?

yxes2013 Newbie
Currently Being Moderated

Hi All,


I want to rename table or synonym owned by HR as a SYS user.


SQL> rename hr.emp to hr.emp_old;


ERROR at line 1:

ORA-01765: specifying owner's name of the table is not allowed



Thanks a lot,



  • Correct Answers - 10 points
  • Helpful Answers - 5 points