If you’re receiving the ORA-28104: input value for statement_types is not valid error, it might be because you are trying to apply a row-level security policy to a table in a database that has been upgraded to 12.2 or greater… 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-30354: Query Rewrite Not Allowed on SYS Relations
The most common reason people get the ORA-30354: Query Rewrite Not Allowed on SYS Relations error is because they’re trying to create a materialized view on a table that exists in the SYS schema. This is a security feature in… 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
“ORA-00904: invalid identifier” with FORALL Loop
Spent an embarrassingly long period of time on an error with a FORALL loop. Can you see what my error is? Every time I ran the above block of code, I would get the following error: Error report – ORA-06550:… Read More
Oracle Network Toubleshooting Guide
I hate troubleshooting Oracle Network Problems the most!!! I would MUCH rather see an ORA-600 error. Because I’ve come across these errors and I know how painful they can be, I’ve set up this little troubleshooting guide that will hopefully… Read More
Summing Interval Data Types
Something I’ve occasionally thought would be really nice is if Oracle had a good way of summing interval data types, much the same way that you can SUM() number data types. Occasionally I’ve designed processes that record start and stop… Read More
How to tell if you have a multi-pass hash join
A hash join can be either an optimal hash join, a one-pass hash join, or a multi-pass hash join. Optimal hash joins – The entire build table fits nicely into memory One-pass hash joins – The build table did not… Read More
Handy trick to avoid ORA-54013: INSERT operation disallowed on virtual columns
In some regards, virtual columns are great: Virtual columns don’t take up physical disk space, which allow for skinnier tables. However, an annoyance with virtual columns is Oracle will give you an ORA-54013 error if you try to insert a… Read More
How to cancel a query in SQL Developer
A common question that user’s of Oracle’s SQL Developer ask is “How can I cancel a query in SQL Developer?” Many times, the reason for this is, out of the box, SQL Developer uses a jdbc “thin” driver. This thin… Read More