Tips
Tips
Oracle error messages
-
Update a referenced column in a MERGE statement
Here's how to update a referenced column in a MERGE statement. Continue Reading
-
Identifying fragmented indexes that should be rebuilt
This tip will help address performance issues when Oracle stops using indexes on highly volatile tables. It identifies indexes that are fragmented and should be rebuilt. Continue Reading
-
Compile all invalid objects
Script to compile all invalid dependent objects at once. Continue Reading
-
How to avoid 'mutating table' errors
A "mutating table" error can be avoided by writing a procedure/function that declares the pragma autonomous_transaction. Continue Reading