Problem solve

Problem solve

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

• How to complete an Oracle installation on Linux

  Database Backup and Recovery expert Brian Peasland explains how to complete an Oracle installation on Linux including how to migrate and export an Oracle 8i production database. 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

• ORA-06550 error when importing a 10.2 dmp file into a 9.2 database

  An Oracle user asks Database Backup and Recovery expert Brian Peasland why they are getting the ORA-06550 error error when importing a 10.2 dmp file into a 9.2 database.Continue Reading

• Using exp and imp for Oracle Database when switching platforms

  Database Design and Architecture expert Brian Peasland answers a reader's question about importing a dump of an Oracle Database from a previous Windows machine to a Linux machine.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