How Oracle Rename Stored Procedure
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
RENAME TO
How Oracle Rename Sequence
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
How Oracle Rename View
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
How Oracle Rename Synonym
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
How Oracle Rename Table
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
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
How to Resolve ORA-03001: unimplemented feature
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
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
How to Resolve ORA-39325: TABLE_EXISTS_ACTION cannot be applied to
ORA-39325 I found a table was not imported during data loading by impdp. After doing some investigation, I saw error ORA-39325 in the log. ORA-39325:… Read More »How to Resolve ORA-39325: TABLE_EXISTS_ACTION cannot be applied to
How to Change Column Order and Position
One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »How to Change Column Order and Position