-
Using nested SQL string functions to find ERP customer values in a table
SQL expert Rudy Limeback explains the value of nested SQL string functions when extracting the ERP customer value for all rows in a table.
-
Which backup strategy should I use for my Oracle 10g database?
Database Backup and Recovery expert Brian Peasland explains how multiple backup strategies exist to backup an Oracle database.
-
RMAN catalog backup: One catalog vs. multiple catalogs
Database Backup and Recovery expert Brian Peasland explains why the best approach is to have one Recovery Catalog for all databases.
-
Do DDL statements roll back, and why?
An Oracle user asks if DDL statements roll back and why they would not be written to roll back segments. Read the answer here.
-
Increasing Oracle storage capacity by moving to a new storage with minimum downtime
Looking to move to a higher Oracle storage capacity with minimum downtime? Read this tip from expert Brian Peasland.
-
Using Undo Tablespaces vs. rollback segments in Oracle 9i, 10g
Expert Brian Peasland explains how Undo Tablespaces and Undo Segments can be used an alternative to rollback segments in Oracle 9i and 10g.
-
Oracle error 942 when exporting a schema
Expert Brian Peasland explains how to solve Oracle error 942 when exporting a schema.
-
Tips for how to size an Oracle server
Using the usage patterns on an existing server, Database Design and Architecture expert Brian Peasland explains how to size an Oracle server.
-
Can the Oracle database schema be cleared without dropping?
An Oracle user asks if the Oracle database schema can be cleared without dropping. Read Brian Peasland's answer here.
-
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.
-
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.
-
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.
-
How to achieve zero downtime for maintenance on the Oracle database
Learn how to achieve zero downtime for maintenance on the Oracle database, and learn which maintenance operations need to be performed offline vs. online in this tip from database Backup and Recove...
-
Is Linux certification necessary for my job in Oracle?
Expert Michael Hillenbrand discusses whether Linux certification is necessary for a job in Oracle.
-
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.
-
The SQL REPLACE function
SQL Expert Rudy Limeback answers an Oracle user's question about the REPLACE function.
-
SQL query to combine rows
Expert Rudy Limeback explains how to write a query in SQL that will combine rows in a table.
-
CASE expressions in the ORDER BY clause
SQL expert Rudy Limeback discusses using a CASE expression in the ORDER BY clause.
-
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.
-
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.
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Submit a question to our experts