Oracle RENAME Statementby Ed ChenOctober 3, 2022October 20, 2022RENAME 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
How to Resolve ORA-01765: specifying owner's name of the table is not allowedby Ed ChenJune 22, 2022May 10, 2023ORA-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