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...
SPOUG2024 chronicle

SPOUG2024 chronicle

I’m writing these lines on my way back to Valencia after attending the annual SPOUG event in Madrid. The Oracle Users Group of Spain has grown strong, and the event was centered around six conference rooms where, simultaneously, a series of talks and presentations on...