Testing the connection to the Oracle server
Test the connection to the Oracle server to determine if the federated server is properly configured to access Oracle data sources.
About this task
You can test the connection to the Oracle server by using the server definition and user mappings that you defined.
Procedure
Open a pass-through session and issue a SELECT statement
on the Oracle system tables.
If the SELECT statement returns
a count, your server definition and your user mapping are set up properly.
For
example:
SET PASSTHRU remote_server_name
SELECT count(*) FROM sys.all_tables
SET PASSTHRU RESET
If the SELECT statement returns an error, you should troubleshoot the connection errors.