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

    How do I rename table or synonym?

    yxes2013

      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