11 Replies Latest reply: Oct 17, 2013 10:38 AM by jgarry RSS

    How do I rename table or synonym?


      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,