KUP-01005: syntax error: found “hash” (How to fix on an External Table)

In this article, I’ll be discussing how to fix the “KUP-01005: syntax error: found “hash”” error when selecting from an external table. Here’s the error in its entirety:ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-29400: data cartridge errorKUP-00554: error encountered while parsing… Read More

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