Ask the Experts

Ask the Experts

• File permissions when doing an RMAN backup

  Oracle expert Brian Peasland explains why an error message may be related to file permissions.  Continue Reading

• How to archive and decommission a database

  An Oracle user asks the best way to archive and decommision a 5GB Oracle 7.3 Database.  Continue Reading

• What are the differences between database migration and database upgrades?

  An Oracle user asks about the differences between database migration and database upgradation.  Continue Reading

• Taking export for all schemas

  An Oracle user asks what syntax to use when taking full export of a database without data and for all schemas.  Continue Reading

• Exporting with LOBs

  An Oracle user asks how to make sure LOBs get exported when doing a schema level export.  Continue Reading

• Importing tables with integrity constraints

  An Oracle user asks why they are receiving errors when importing a table with integrity constraints.  Continue Reading

• Converting Long Raw to Blob

  Expert Greg Williams explains when and how to convert Long Raw to Blob using PL/SQL.  Continue Reading

• Oracle certification tips and advice

  A SearchOracle.com user asks how to become a Systems Analyst, focusing on technologies such as Oracle and Java, with no prior experience in Oracle.  Continue Reading

• Is Oracle 11i Applications or E-Business Suite a variation of Oracle Forms?

  An Oracle user asks if Oracle 11i Applications or E-Business Suite are variations of Oracle Forms.  Continue Reading

• What is the difference between a relational database and a repository?

  An Oracle user asks the difference between a relational database and a repository.  Continue Reading

• Using the DRIVING_SITE hint

  Oracle expert Brian Peasland explains how the DRIVING_SITE hint can help an optimizer to run a remote query on either the local or the remote system.  Continue Reading

• Running two instances of Oracle on one server

  An Oracle user asks what kind of performance issues may occur when running two instances of Oracle on the same server.  Continue Reading

• Solving the ORA-1650 error message

  Oracle expert Brian Peasland explains how to solve the ORA-1650 error message.  Continue Reading

• Installing Oracle 11g on Linux

  Oracle expert Brian Peasland provides a document that explains how to install Oracle 11g on Linux.  Continue Reading

• Using transparent gateways to access data in SQL Server

  Oracle expert Brian Peasland explains how to use transparent gateways to access data in SQL Server.  Continue Reading