Index Problem

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 Received on Wed Oct 06 1999 - 09:39:59 CDT