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

• Five Oracle tips in five minutes

  These five quick Oracle tips, including scripts and SQL shortcuts, can make your life as a DBA a bit easier.  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

• Dropping objects without ORA-00942 errors

  This tip enables you to install or drop objects without getting an Oracle error, even if the object doesn't exist.  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

• Error when installing an Oracle patchset on AIX 4.3.2 or higher

  Here's a way to tackle an error message when installing an Oracle patchset on AIX 4.3.2.  Continue Reading