A server with server class oraodbc is Oracle version 8.0 or later.
Sybase certifies the use of version 8.0.03 of Oracle's ODBC driver. Configure and test your ODBC configuration using the instructions for that product.
The following is an example of a CREATE EXISTING TABLE statement for an Oracle server named myora:
CREATE EXISTING TABLE employees AT 'myora.database.owner.employees'
Due to Oracle ODBC driver restrictions, you cannot issue a CREATE EXISTING TABLE for system tables. A message returns stating that the table or columns cannot be found.
Data type conversions: Oracle