Alan,

It is you again haha. : -) Thanks!
I tried your suggestion and it complained that the tablespace "INDX"
already existed. So should I drop it first? How do I drop it? Do I need
to drop all the tablespaces and then recreate?

I also run this:

SQL> show parameter cache;

Name Type
Value

db_16k_cache_size big integer
36M
db_cache_advice string
ON
object_cache_optimal_size integer
102400

All of the rest has a value of "0".

I tried to change the "db_16k_cache_size" to 100M, however I got
"ORA_02097: parameter cannot be modified because specified value is
invalid ORA-00384 : Insufficient memory to grow cache" error.

Please excuse me if I asked really rudimentary questions. I am kind of
new to the Oracle stacks as I said.

Thanks again!!

Zara

Alan Cuartero wrote:
> 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!
>
>


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!