ORA-01031: insufficient privileges

ORA-01031: insufficient privileges is probably my least favorite error, because more often than not, it’s an indication of a people problem, and people problems are oftentimes more difficult to fix than technical problems. Having said that, sometimes people issues can… Read More

ORA-65049: Creation of local user or role is not allowed in this container

If you’re getting an ORA-65049 error, you’re probably trying to create a local database user (a local database user is a user without a c## prefix) in the CDB$ROOT container for a multi-tenant database. A few solutions exist: If you’re… Read More

Filters in the JOIN Clause vs. WHERE Clause: Does It Matter?

Here’s a question I’ve been asked multiple times from multiple people: “Does it matter I put filters in the join clause vs in the WHERE clause?  And if so, which one is better?” Example: vs. So does it matter? Answer:… Read More