To load the Oracle database schema
On the Schema menu, click Load.
The Load Schema to Repository dialog box appears.
Select Data Manager Type as Oracle from the drop-down list.
Enter the host name or the host IP address, the port number, and the Service Name in the respective fields.
If there are multiple network adapters / addresses, enter the host IP address instead of the host name to avoid name resolution issues. When a host name is used, Data Exchange acquires the first available IP address from Domain Name System (DNS) when the Administrative Service starts.
Note: The Service Name is a simple name for a service that resolves to a connect descriptor. You can initiate a connect request by passing a user name and password along with a net service name in a connect string, for the service to which you want to connect. It is configured in the tnsnames.ora file, which is located at the following location in the Oracle database: <oracle_installation_path>\NETWORK\ADMIN
Enter the valid credentials in the Login User and Password fields to connect to the database.
Notes:
DDW supports loading the Oracle database schema only if your user account is not maintained by Oracle.
If the user account is maintained by Oracle, DDW will not load the tables and columns under the schema.
The login usercode should have the “Create Session” privilege to load the Oracle database schema.
Select "Remember Me" to save your credentials for automatic login the next time you load the schema.
(Optional) Click Verify Connection to ensure that a connection can be established with the database.
If the connection is successful, a success notification appears. If the connection fails, an error message appears.
Click OK.
After the schema is loaded successfully, a status message is shown in the DDW status bar. The time taken to load a schema depends on its size.
You can click Cancel to cancel the process.