5.3 Defining an Oracle URL

Table of Contents Previous Next


5 Building the toolkit.properties File : 5.3 Defining an Oracle URL

When migrating from an Oracle database, SRC_DB_URL should contain a JDBC URL, specified in one of two forms. The first form is:
jdbc:oracle:thin:@host_name:port:database_id
jdbc:oracle:thin:@//host_name:port/{database_id|service_name}
SRC_DB_USER should specify the name of a privileged Oracle user. Note: The Oracle user should have DBA privilege to migrate objects from Oracle to Advanced Server. The DBA privilege can be granted to the Oracle user with the Oracle GRANT DBA TO user command to ensure all of the desired database objects are migrated.
SRC_DB_PASSWORD must contain the password of the specified user.

5 Building the toolkit.properties File : 5.3 Defining an Oracle URL

Table of Contents Previous Next