Problem Note 41093: An error occurs and you cannot access an Oracle table when you use a schema name or a user ID that contains a dollar sign ($)
 |  |  |  |  |
If an Oracle user ID or schema name contains a dollar sign ($), you must add double quotation marks around the user ID or schema name when you register Oracle tables from SAS® Management Console. After you register the table, when you try to access these tables from SAS® Enterprise Guide®, you might receive an error saying that the table does not exist, as shown in this example:
"SELECT * FROM "Ctaf2$Current".DEM" ERROR: File TEST2.DEM.DATA does not exist.
You can either work around the problem or download a hot fix.
To work around this issue, do the following:
- Put double quotation marks around the user ID or schema name in SAS Management Console.
- Register the tables.
- Remove the quotation marks so that you can access the ID or name from SAS Enterprise Guide.
To access the hot fix for this issue, click the Hot Fix tab in this note.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Professional 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Professional x64 | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 9.3 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate x64 | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled AIX | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled HP-UX | 9.3 | 9.3 TS1M1 | ||||
| 64-bit Enabled Solaris | 9.3 | 9.3 TS1M1 | ||||
| HP-UX IPF | 9.3 | 9.3 TS1M1 | ||||
| Linux | 9.3 | 9.3 TS1M1 | ||||
| Linux for x64 | 9.3 | 9.3 TS1M1 | ||||
| Solaris for x64 | 9.3 | 9.3 TS1M1 | ||||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#41093A fix for this issue for Base SAS 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F98.html#41093| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-03-01 16:29:21 |
| Date Created: | 2010-09-30 14:15:50 |