Problem Note 16504: "ORA-00942 table or view does not exist" error when using SAS/ACCESS
Interface to Oracle with the bulkload utility
You may receive the following errors with SAS/ACCESS Interface to Oracle
when using the BULKLOAD=YES option:
SQL*Loader-951: Error calling once/load initialization
ORA-00942: table or view does not exist
BULKLOAD=YES instructs the SAS/ACCESS Interface to load data into Oracle
using the Oracle Bulkload utility.
Oracle requires that the major version of the Oracle client and database
match when using Direct Path Load. The SAS/ACCESS Interface to Oracle
sets DIRECT=TRUE to use Direct Path Load by default.
If your Oracle client and database versions differ, you will need to
upgrade one or both to avoid this error. Another possible workaround
would be to use the Conventional Path Load method instead. This method
does not require a match in the versions of your Oracle client and
database. You can use the BL_DIRECT_PATH option to set Conventional
Path Load. For example,
data oralib.bulk_load_table(bulkload=yes bl_direct_path=no);
set mydata.sasds;
run;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Linux on Itanium | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |
Linux | 9.1 TS1M3 | |
64-bit Enabled AIX | 9.1 TS1M3 | |
64-bit Enabled HP-UX | 9.1 TS1M3 | |
HP-UX IPF | 9.1 TS1M3 | |
Tru64 UNIX | 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: | Problem Note |
Priority: | low |
Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Oracle
|
Date Modified: | 2005-11-21 12:47:06 |
Date Created: | 2005-11-14 11:06:36 |