Problem Note 36595: The BL_DELETE_FILES option deletes all file types(.ctl, .log, and .dat) that are created with the bulk loader
 |  |  |  |  |
When you use the Oracle SQL*Loader utility with the default BL_DELETE_FILES=YES option in SAS/ACCESS® Interface to Oracle, all file types (.ctl, .log, and .dat files) that are created by the bulk loader are deleted. However, when you use BL_DELETE_FILES=NO, none of the file types are deleted, which causes disk space for large data volumes to fill up.
The BL_DELETE_FILES option does not enable you to specify that only certain file types should be deleted.
Select the Hot Fix tab in this note to access the hot fix for this issue.
You can use the new option BL_DELETE_ONLY_DATAFILE, which is included in this hot fix, if you want to keep .LOG and .CTL files. This new option overrides the BL_DELETE_FILES option.
The following table shows the what happens when various combinations of these two options are specified:
BL_DELETE_FILES BL_DELETE_ONLY_DATAFILE Action Taken by the Oracle Engine
---------------------------------------------------------------------------------------
YES NO The .dat files are not deleted;
.ctl and .log files are deleted.
(Note: The BL_DELETE_FILES option
is overridden.)
NO NO None of the files are deleted.
YES YES The .dat files are deleted;
.ctl and .log files are not deleted.
Note: The BL_DELETE_FILES option
is overridden.)
NO YES The .dat files aredeleted; .ctl
and .log files are not deleted.
(Note: The BL_DELETE_FILES option
is overridden.)
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#036595A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#036595| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle |
| Date Modified: | 2011-07-26 10:26:50 |
| Date Created: | 2009-07-22 17:02:23 |