Zara,
Since the table already exists you may want to try this command. I'm
having the exact same problem on an install
Alter database datafile 'c:\otm\data\indx001.dbf' autoextend on maxsize
4000M
Make sure c:\otm\data\indx001.dbf - is the path to your data file
I think you then need to drop all the stuff running:
@create_glog_users.sql
I'm trying all this right now so I'll let you know if it works.
I think there is a bug in the create_gc3_tablespaces.sql
John
____________________________________________
STEPHEN CRAIG
CP Consulting
This message is confidential and may be legally privileged. It is
intended
only for its addressees. Its use in any way by anyone else is
prohibited.
-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto
wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of idqpbi
Sent: Wednesday, December 13, 2006 8:45 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Re: IMP-00017: following statement failed with ORACLE error
1658; create index ....
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!
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
