11 Replies Latest reply on Oct 17, 2013 3:38 PM by jgarry

    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,