Usage Note 18184: SQL*Loader-951 received bulkloading to an Oracle table with an index
using PARALLEL=TRUE
Using SAS/ACCESS Interface to Oracle to bulkload into an Oracle table
that contains indexes using PARALLEL=TRUE will result in the following
error:
SQL*Loader-951: Error calling once/load initialization
ORA-26002: Table xxx.xxx has index defined upon it.
The reason for this error is that Oracle's SQL*Loader can't be used on
Oracle tables that contain indexes with the option, PARALLEL=TRUE.
To workaround this error, the index can be kept but the option,
PARALLEL=TRUE, must be removed. Another option is to keep PARALLEL=TRUE
and add the index after the bulkload is complete.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Oracle
|
| Date Modified: | 2006-07-31 12:26:25 |
| Date Created: | 2006-07-31 12:26:25 |
