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.
What is the difference between a database engineer, architect and administrator?
Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Users consider Oracle EBS R12 upgrade as Premier Support for 11i ends
Premier Support for Oracle E-Business Suite11i ends Nov. 30, and end users must decide whether to move to Extended Support, which brings fewer features and higher maintenance fees, or do an EBS R12 upgrade. Continue Reading
Oracle RAC on VMware gets no support from Oracle
Oracle won’t support Oracle RAC on VMware at all, largely for political and outdated technical reasons, according to end users, consultants and vendors. Continue Reading
-
Oracle licensing, support on VMware still a hindrance
Database pros say Oracle’s licensing and support policies for Oracle on VMware are still a pain point, mainly because Oracle considers VMware to be “soft partitioning.” Continue Reading
Using BETWEEN with DATETIMEs in SQL
Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates. Continue Reading
LOB tables missing with exp/imp move of schema
I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing.Continue Reading
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.Continue Reading
Employees with the same first and last names in SQL
How do I SELECT a list of employees who have the same last and first name in SQL?Continue Reading
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued?Continue Reading
Sorting a clob column
I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out?Continue Reading
-
Introduction to BPEL
It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager.Continue Reading
Steps to implement RAC
How can I implement a RAC application in Oracle Database in my system?Continue Reading
Oracle RAC design: The effects of component failure
This excerpt from the book "Oracle 10g Grid & Real Application Clusters" shows expert techniques used by real-world RAC professionals for designing a robust and scalable RAC system. This section provides a quick look at the effects of component ...Continue Reading
Oracle vs. Sybase: 10 reasons to use Sybase on Linux
Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle.Continue Reading
Regulatory compliance and the DBA: What you need to know
At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the ...Continue Reading
Performance tuning a RAC implementation
The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps.Continue Reading
ON DELETE RESTRICT
I would like to know where we use DELETE RESTRICT?Continue Reading
Difference between function, procedure and trigger
What is the difference between a function, a procedure and a trigger? I know the basic differences, but I would like to know the answers based on the performance tuning aspect.Continue Reading
Multiple instances on a single database
Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?Continue Reading
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery?Continue Reading
ORA-12801 and ORA-01652 errors on running query
PL/SQL to display all tables
XML for data architects: Designing for reuse and integration (Chapter 8)
Merging datasets with NULL values
A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how.Continue Reading
Telling EXECUTE IMMEDIATE to commit
How to validate zip code, city, and state code
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
Age constraint on a date column
COALESCE on three columns
Getting a row number in a group
Checking if row is locked before using it in a procedure
Assignment operators explained