Problem solve

Problem solve

Get help with specific problems with your technologies, process and projects.

• When to use the Oracle ANALYZE command and how to avoid complications

  An expert explains when and how the Oracle ANALYZE command should be used and provides examples to help you avoid complications when using the command. Continue Reading

• Can I use Oracle FTP for importing data from Oracle 11g into 10g?

  Database Backup and Recovery expert Brian Peasland explains why the Oracle FTP utility cannot be used for importing data from Oracle 11g into 10g. Continue Reading

• Is Linux certification necessary for my job in Oracle?

  Expert Michael Hillenbrand discusses whether Linux certification is necessary for a job in Oracle. Continue Reading

• Business Analyst vs. Data Architect: Who should do the source-to-target mapping?

  An Oracle user asks who should do the source-to-target mapping in a company--the Business Analyst or Data Architect. Continue Reading

• CASE expressions in the ORDER BY clause

  SQL expert Rudy Limeback discusses using a CASE expression in the ORDER BY clause. Continue Reading

• SQL to select rows 1000 through 3000 in a table

  An Oracle user asks if they can use SQL to select rows 1000 through 3000 in a table.Continue Reading

• The SQL REPLACE function

  SQL Expert Rudy Limeback answers an Oracle user's question about the REPLACE function.Continue Reading

• SQL query to combine rows

  Expert Rudy Limeback explains how to write a query in SQL that will combine rows in a table.Continue Reading

• Partitioning a table in Oracle to improve performance

  An Oracle user asks if partitioning a table will improve performance.Continue Reading

• User vs. schema in Oracle

  An Oracle user asks what the difference is between a user and a schema.Continue Reading

• Is there any tool to migrate data from DB2 to Oracle?

  Expert Brian Peasland talks about the Oracle Migration Workbench, which can migrate data from DB2 to Oracle.Continue Reading

• Can I populate tables in MS ACCESS and upload to the Oracle server?

  Database Design and Architecture expert Brian Peasland explains his procedure for populating tables in MS ACCESS and upload it to the Oracle server.Continue Reading

• I have space in log_arch_dest, so why am I getting the ORA-00257 error?

  An Oracle user asks why they are getting the ORA-00257 error even though they have sufficient space in log_arch_dest.Continue Reading

• Does making an Oracle datafile READ ONLY after a backup change the file?

  An Oracle user asks if making a datafile READ ONLY after a backup changes the file.Continue Reading

• How to restore a database using RMAN to Point in Time

  An Oracle user asks how to restore a database using RMAN to Point in Time.Continue Reading