Hi there,
How to rename a table's name in another user?
i logined as ops$oracle, and tried to rename a table. got the following errors:
SQL> rename hr.emp1 to hr.emp2;
rename hr.emp1 to hr.emp2
*
ERROR at line 1:
ORA-01765: specifying table's owner name is not allowed
SQL> alter session set current_schema=hr;
Session altered.
SQL>
SQL> rename emp1 to emp2
2 /
rename emp1 to emp2
*
ERROR at line 1:
ORA-01031: insufficient privileges
NOTES:
1. user ops$oracle has dba role privilege.
2. don't reset the password for HR user.
3. don't re-create the emp1 table. just rename it to emp2.