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
For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c. Theoretically, there's no need… Read More »SYS Packages Granted to Public
USER_LOCK USER_LOCK is not a default package of SYS, you need to install it before using it. SQL> conn / as sysdba Connected. SQL> @?/rdbms/admin/userlock.sql… Read More »How to Install USER_LOCK Package
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