For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all,
11.2.0.1
How do you rename scott.emp to scott.emp2 as SYS?
SQL> connect / as sysdba
Connected.
SQL> rename scott.emp to scott.emp2;
*
ERROR at line 1:
ORA-01765: specifying owner's name of the table is not allowed
Thanks all,
pK