Hi,
During my configuring the oracle database for the OTM 5.5.1 server
I ran the following according to OTM 5.5.1 Admin Guide page 3-19:
/imp parfile=imp_otmv55_partition.par
userid=system/<SYSTEM_PWD>@<CON_STR>
(using my own pwd of course)
/
and it seemed that the list of tables were imported, then it failed with
*IMP-00017: following statement failed with ORACLE error 1658; create
index......*
later on it also failed on "alter table....." since there is no primary
key for some tables, so there is no way to set up foreign key
relationships....
It seems that the export was done by using the SYS user.
So my import log file was full of those similar errors. What happened?
Please help!!!
I don't understand that I am using the .dmp and .par file provided by
OTM installer, and why it should fail
Was this related to the previous error that I could use the SYSTEM user
to grant execute on some objects owned by glogdba and glogowner??
I will try to generate a log file using "imp" options to see what those
commands are.........Kind of lost, how can I get the data into the OTM
database??
Zara
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!
Linear Mode
