Tips

Tips

Oracle error messages

• Changing to a shared server

  To change your Oracle 9i release 2 database from a dedicated server to a shared server, you must change the number of dispatchers to at least one. But if you run this statement you will receive an error message. The alter system statement is an ...  Continue Reading

• 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 including those with syntax errors

  With this script, you can see not just invalid objects, but also those with syntax errors.  Continue Reading

• Avoid 'cannot extend rollback segment' error when deleting rows

  Here is how delete as many rows as you like without having to worry about RBS size.  Continue Reading

• Compile all invalid objects

  Script to compile all invalid dependent objects at once.  Continue Reading

• RBS monitor to catch ORA-1555 errors

  Why you get ORA-1555 errors and how to avoid them.  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