Problem Note 16328: "ERROR: Insufficient authorization to access .ctl file" during an Oracle
bulkload
Attempting to create an Oracle table using bulkload may result in the
following error:
ERROR: Error attempting to CREATE a DBMS table. ERROR: Insufficient
authorization to access /usr/BL_xxx.ctl
This error occurs if you don't have the appropriate permissions to
create the CTL file that gets created by the Oracle bulkload utility. To
workaround this problem, either give the appropriate write permissions
to this folder or direct the CTL file to be written in an alternate
location using the BL_CONTROL= data set option. For example,
libname ora oracle user=xx password=xx path=xxx;
data ora.new (BL_CONTROL='xx/xx/CntlFile.ctl');
set sashelp.class;
run;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
Microsoft Windows XP Professional | 9.1 TS1M3 | |
Linux on Itanium | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
Linux | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
HP-UX IPF | 9.1 TS1M3 | |
64-bit Enabled AIX | 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: | |
Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2005-11-08 18:42:07 |
Date Created: | 2005-10-18 09:59:33 |