Re: Index Problem

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 Wed Oct 06 1999 - 14:02:05 CDT