Problem solve

Problem solve

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

• Allocating bytes as extents in Oracle

  Oracle expert Brian Peasland explains how Oracle allocates bytes in extents, or chunks. Continue Reading

• How to move data faster with a database link

  Oracle expert Brian Peasland explains how to move data across a database link to speed up an import. Continue Reading

• How can I solve the ORA-4030 error?

  An Oracle user asks how to solve the ORA-4030 error: out of process memory . Continue Reading

• How to implement a ref cursor called in a stored procedure

  Expert Brian Peasland explains how and when to implement a ref cursor called in a stored procedure. Continue Reading

• Why am I getting the ORA-00381 error when initializing the parameter?

  An Oracle user asks why they are getting the ORA-00381 error when initializing the parameter. Continue Reading

• Performance issues in Oracle 9i

  An Oracle user asks if upgrading their database to 10g will help solve performance and space management issues in Oracle 9i.Continue Reading

• What is the difference between an instance and mounting in Oracle?

  An Oracle user asks what the difference is between an instance and mounting.Continue Reading

• What is Unix shell scripting?

  Oracle expert Brian Peasland explains about Unix shell scripting.Continue Reading

• How to get history of modified data from Oracle databases

  An Oracle user asks how to get the history of data modified from an Oracle database.Continue Reading

• Export dump with files larger than 2 GB

  An Oracle user asks how to create an export dump with files larger than 2 GB.Continue Reading

• Benefits of a 3NF level of normalization

  An Oracle user asks expert Brian Peasland his general opinion regarding normalizing data in an Oracle database.Continue Reading

• How does Oracle identify which password file to use?

  An Oracle user asks how the database identifies which password file to use.Continue Reading

• Tip: Exposing logical attributes with virtual columns

  Data modelers are often faced with the dilemma of how to model logical attributes in their data warehouse schema design. A new feature in Oracle 11g called virtual columns solves this dilemma by exposing logical attributes while reducing object ...Continue Reading

• Errors when importing from production to development

  My production environment is in 9.2. My development crashed. Then I installed the software 9.1 on sunsparc (which is the version we have). When I want to import the (full mode) taken from production (9.2 version) into development (9.1 version), it ...Continue Reading

• Failed stored procedure through db link in Oracle

  An Oracle user asks why a stored procedure through db link from Oracle 10g to 8i is failing.Continue Reading