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
We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages,… Read More »GRANT EXECUTE on SYS Package to PUBLIC
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
Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle