Ask the Experts

Ask the Experts

• Which normal form is used most?

  SQL expert Rudy Limeback explains what normal form is used in most database projects.  Continue Reading

• Update a specific column in a field or row?

  An Oracle user asks if SQL can be used to update a specific column in a field.  Continue Reading

• ORA-27101 error: shared memory realm does not exist

  An Oracle user asks why their machine is abnormally terminating and they are receiving the ORA-27101 error.  Continue Reading

• How to set up a job for an SQL query in Oracle 10g Grid Control

  Oracle expert Brian Peasland explains when and how to set up a job in Oracle to run an SQL statement.  Continue Reading

• Receiving the ORA-01652 error with no specified tablespace

  An Oracle user asks why they are receiving the ORA-01652 error but there is no tablespace specified in the error.  Continue Reading

• Why am I getting the ORA-03113 error when trying to refresh a materialized view?

  An Oracle user asks expert Brian Peasland why they are getting the ORA-03113 error when trying to refresh a materialized view completely.  Continue Reading

• Remote database administration: What to look for in a provider

  Managing an Oracle shop expert Michael Hillenbrand talks about his experiences with remote database administration.  Continue Reading

• Why do I have to start my Oracle database manually?

  An Oracle user asks why they are having to start their Oracle database manually using SQL plus.  Continue Reading

• ORA-06550 error when exporting a database

  An Oracle user asks why they may be getting an error when exporting a database.  Continue Reading

• Hot backup when Oracle Database is up

  An Oracle user asks Database Backup and Recovery expert Brian Peasland the following question: "What is the procedure for doing a hot backup when the database is up?"  Continue Reading

• SQL query for co-authored books

  SQL expert Rudy Limeback gives advice for writing a query that involves a number of tables.  Continue Reading

• Connecting tables in a database

  SQL Expert Rudy Limeback gives advice on finding information on primary and foreign keys to connect tables in a database.  Continue Reading

• IN list or series of OR conditions?

  SQL expert Rudy Limeback explains the advantage of using the IN list in this situation.  Continue Reading

• Querying complex derived tables

  An Oracle user asks SQL expert Rudy Limeback how to run a query when the inner query results come from five different tables.  Continue Reading

• Changing a NULL column to NOT NULL

  An Oracle user asks SQL expert Rudy Limeback how to repopulate a table after modifying the table to NOT NULL.  Continue Reading