Re: Index Problem

Hi there,

    The Oracle version is 7.3.4 and OS is AIX 4.1.5.

neuwn_at_my-deja.com wrote in message <7tg6b3$88f$1_at_nnrp1.deja.com>...
>What version of Oracle?
>
>In article <7tfmus$rrk2_at_imsp212.netvigator.com>,
> "ccdicky" <ccdicky_at_yahoo.com> wrote:
>> Hi everybody,
>>
>> I have a table which few hundred records are at least inserted into.
>There
>> are three indexes created in this table, including the primary key.
>The
>> value of the primary key is random postive integer in a certain large
>range,
>> for example 100000000-999999999. As you might see the charateristic
>of the
>> primary key, rebuilding the index for primary key should be required
>> periodically to avoid the insertion failure.
>>
>> However, with this remedy method, after more than 2 month's insertion
>> without any error, I got a ORA-600 internal error again when trying to
>> insert some records into this table. Finally, the only way I found to
>> resolve the problem is to drop the index, and then re-create it. So
>anyone
>> can tell me what is the different between index rebuild and index re-
>create.
>> In additon, what else way can resolve my problem too.
>>
>> During working with the problem, I found that I could insert one or
>less
>> than 7 records into the table successfully; but not for more than 8
>records.
>> It is quite interesting for me. Idea about this??
>>
>> Thanks in advance. Any help would be appreiated.
>>
>> Dicky
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Oct 07 1999 - 09:49:09 CDT