Oracle RENAME Statement
RENAME Syntax For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as: RENAME old_name TO new_name; There're only… Read More »Oracle RENAME Statement
ORA-01765
How to Resolve ORA-01765: specifying owner's name of the table is not allowed
ORA-01765 Saw an error ORA-01765 when tried to rename a table by SYS. SQL> conn / as sysdba Connected. SQL> rename hr.employees to hr.employees_bak; rename… Read More »How to Resolve ORA-01765: specifying owner's name of the table is not allowed