Rational ProjectConsole Maintenance Tool Help
To provide information about the Oracle data to migrate:
a. From the Database type list, select the database type.
b. In the Database server field, enter the machine name of the server where the Oracle database is running.
a. In the SID (Oracle System Identifier) field, enter the name of the database instance that will be used for the schema repository.
b. In the Username field, enter the user name required to log in to your Oracle schema repository.
c. In the Password field, enter the password required to log in to your Oracle schema repository.
a. In the SID (Oracle System Identifier) field, enter the name of the database instance that will be used for the data warehouse.
b. In the Username field, user name required to log in to your Oracle data warehouse.
c. In the Password field, password required to log in to your Oracle data warehouse.
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.