Zara,

You may have run out of space. Its been my experience that the default
tablespace data files are a little undersized for the import. Check your log
for the first occurrence of an ORA-01658 error all the subsequent errors
would be a result of that initial one. If you have it try adding a datafile
to the tablespace in question. Another possible solution is to increase the
MAXSIZE value for the datafile and turn on AUTOEXTEND if its not on already.
Something like this for the initial create.

CREATE TABLESPACE INDX
DATAFILE '/opt/whaterver/path/youre/using/INDX01.dbf'
SIZE 1024000K REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 4096000K
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/

Then rerun the create_glog_users.sql in order to drop and recreate the users
(which will drop cascade all their objects and data). Then retry the import.

Hope this helps.

-Alan


On 12/13/06 6:27 PM, "idqpbi" <idqpbi (AT) gmail (DOT) com> wrote:

> 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!



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!