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,

 

11.2.0.1

 

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,

zxy

Legend

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