We are running Oracle8 w/ the SQL v.2.2 from Oracle 7 - I have a user that is using SAS Access w/Oracle to get to our datawarehouse - when he runs the program using SAS he gets an error of ORA-12154-TNS: Could not resolve service name. I have checked the login; TNS names; applied the ORA8.FIX from Oracle and nothing has worked.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.