Database parameters for migrating Oracle data

Rational ProjectConsole Maintenance Tool Help  

Provide the following information about the Oracle databases that contain the data you want to migrate.

In the Data warehouse information:
In the Schema repository:
In the Data warehouse:

Database connection options:

When you are creating either a new schema repository or user database with Oracle, the Connect Options field displays LOB_TYPE=CLOB. CLOB stands for Character Large Object and is the default value. An alternate selection is LONG. However, CLOB is Oracle's preferred method for storing large objects. It simplifies the way database administrators set up searching on multiline text fields.

You can also use the Connect Options field to change the port number. If the port number of the database is different from the default for Oracle, which is 1521, then the port number should be entered in this field, in the form PORT=port_number.