![]() | ![]() | ![]() | ![]() | ![]() |
If the value of the SCHEMA= option or the DATABASE= option for a DBMS library differs from that of the value for the USERID= option, the DBMSTEMP tables are not deleted when you execute the SCD2 code. As a result, that code will fail the next time you attempt to run it (in the same session or subsequent sessions). When the code fails, the following error message is generated:
ERROR: The ORACLE table <TEMP_NAME> has been opened for OUTPUT. This table already exists, or there is a name conflict with an existing object. This table will not be replaced. This engine does not support the REPLACE option.
The solution is to omit the SCHEMA= option or the DATABASE= option from the ETLSTMP library allocation. This action prevents the schema or database information from being included in the DATASETS procedure; therefore, the software will find and delete the tables.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to Oracle | Windows Vista | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
z/OS | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP1 | |||
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP1 | |||
Microsoft Windows 2000 Server | 9.1 TS1M3 SP1 | |||
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP1 | |||
Microsoft Windows NT Workstation | 9.1 TS1M3 SP1 | |||
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
HP-UX IPF | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Linux | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
OpenVMS Alpha | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP1 | 9.2 TS2M0 | ||
Tru64 UNIX | 9.1 TS1M3 SP1 | 9.2 TS2M0 |