Procedure

How to Resolve ORA-03001: unimplemented feature

by Ed Chen
August 4, 2022September 22, 2022

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 PLS-00123: program too large

by Ed Chen
June 26, 2021August 17, 2021

PLS-00123 When we compile a big program unit, we may get PLS-00123 if it exceeds any one of compiler limitations that Oracle allows. ... declare… Read More »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020September 11, 2022
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Backup PL/SQL Codes in Oracle

by Ed Chen
September 11, 2019August 27, 2021

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 »