A direct load does not compete with other users for database resources, so it can usually load data at near disk speed.
Considerations inherent to direct path loads, such as restrictions, security, and backup implications, are discussed in this chapter.
Oracle Warehouse Builder enables you to connect to data stored in a non-Oracle source, such as Microsoft Excel, using "Oracle Database Heterogeneous Services". Step 1: Install ODBC Driver for Excel To read data from Microsoft Excel, you need the ODBC driver for Excel.
By default, the ODBC driver for Excel is installed on a Windows system.
Step 2: Delimit the Data in the Excel File (Optional) If you want to delimit the data to be imported from the Excel file, then define a name for the range of data being sourced: Step 4: Create the Heterogeneous Services Initialization File To configure the agent, you must set the initialization parameters in the heterogeneous services initialization file.
In the User Message section, we will provide the error message that will be poped out if invalid data is provided.For this article I have created two stored procedures one to read the Excel 97 – 2003 format and other Excel 2007 format.Though the Microsoft Ace Driver can read both still I have used Jet for Excel 97 - 2003 formats.- Select Format only cells that contain - Under Format only cells with select Errors - Click Format...button - Go to the Font tab - Under Color select the same font color as the background (such as white).