Problem solve
Get help with specific problems with your technologies, process and projects.
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