WebSphere Adapter for Oracle E-Business Suite

Creating synonyms

Create synonyms to increase the efficiency of database searches performed during enterprise service discovery. You create synonyms by running a SQL script.

About this task

The size of the database and number of database artifacts in the Oracle E-Business Suite database can lengthen the process of searching through large lists when running the enterprise service discovery wizard to generate objects. Creating the synonyms will help to make the search quicker. In addition, the synonyms help resolve an issue related to the Oracle database driver. The issue is documented in IBM® technote 1218775.

How to perform this task

  1. Open the SQL*Plus tool (or similar program for processing SQL statements).
  2. Run the file ibm_create_synonyms.sql.

    For example, enter: SQL> @C:\samplecontent\ibm_create_synonyms.sql


Terms of use |

Last updated: Mon 30 Oct 2006 03:46:26

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)