[davidli]

nick,
First, thanks for your help. I'm sure that the import of the database is successful. I work out it complete according to the admin guide, but when executed the following i made a mistake,
because i haven't found <otm_install_path>/gc3/glog/oracle directory, i executed @insert_security_roles.sql in the <otm55_install_path>/glog/oracle directory.

from admin guide:
Setup Security Roles
1. Change to the <otm_install_path>/gc3/glog/oracle directory on the Oracle Transportation
Management Application server.
2. In SQL*Plus as the GLOGOWNER user, run:
@insert_security_roles.sql
Migrate the New Database
You must now migrate the new database to the CU3 structure:
Open up a shell (UNIX) or command prompt (Windows) on the APP server
Copyright © 2001, 2008, Oracle. All rights reserved. 3-25
Important: Ensure that your environment is setup correctly by running:
On UNIX: “. <otm_install_path>/install/gc3env.sh”
On Win32: “<otm_install_path>\install\gc3env.cmd”
Change directory to <otm55_install_path>/glog/oracle/script8
In SQL*Plus as user GLOGOWNER, run:
@dbpatch_55.sql
Enter the passwords and connection strings when prompted
Check the log files (dbpatch log and update_content log) to ensure they are error free before
proceeding to the next step
Change directory to <otm55_install_path>/glog/oracle
In SQL*Plus as user GLOGOWNER, run:
@insert_security_roles.sql


I haven't made other mistakes except above.

Thanks again.

davidli.