Insufficient privileges and PL/SQL

Insufficient privileges and PL/SQL

If you have been working with Oracle for some time, you have most likely seen this scenario: From SQL, an operation works. From an anonymous PL/SQL block, it also works. From a stored procedure… ORA-01031: insufficient privileges. The usual way to try to fix it...
Bring your impdp some love

Bring your impdp some love

Imagine you’re planning a database migration between two servers. You’re performing a FULL import into a brand-new DATABASE. You have plenty of good reasons to “reorganize” the entire DATABASE: a SYSTEM tablespace over 60GB, a SYSAUX tablespace...