If you’re using the LISTAGG() function in Oracle, and you’ve encountered the error ORA-01489: result of string concatenation is too long it’s because you’re trying to create a comma-delimited list that is too long for a VARCHAR2. In Oracle, a… Read More
How to Unexpire a Password in Oracle (ORA-28001: the password has expired)
What This Error Means You’re trying to login to an Oracle database and you get ORA-28001: the password has expired. Yikes! This means that the user’s profile forces them to periodically change their password, due to a security precaution. So,… Read More
ORA-12727: Invalid Back Reference In Regular Expression
If you’ve run across ORA-12727: invalid back reference in regular expression, it’s because you’ve referenced a group (a group is an expression enclosed in parenthesis) either that doesn’t exist, or doesn’t exist yet. There are two common reasons for this… Read More
Conditional Compilation Errors in Pl/SQL
Here’s a list of common Pl/SQL Conditional compilation errors, along with what may have caused them. This should allow you to know where to look in your code for errors. This isn’t a complete list, but it should be enough… Read More
ORA-28104: input value for statement_types is not valid.
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