No, you cannot simply rename a function, package or procedure by an ALTER statement, there's no such syntax to support this. All you can do… Read More »How Oracle Rename Stored Procedure
To rename a sequence, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example: SQL> show… Read More »How Oracle Rename Sequence
To rename a view, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example: SQL> show… Read More »How Oracle Rename View
Private Synonym To rename a private synonym, we should RENAME TO statement to rename it, but you have to login as the object's owner. For… Read More »How Oracle Rename Synonym
You can either using SQL statement or GUI tools to rename a table, depending on your requirement. Table Rename by SQL Statement Table Rename by… Read More »How Oracle Rename Table
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-03001 Tried to use RENAME TO statement to rename a schema object, but it failed with ORA-03001. SQL> rename add_job_history to add_job_history_all; rename add_job_history to… Read More »How to Resolve ORA-03001: unimplemented feature