Oracle 9i insertion problem

From: Vlad <vladislavi_at_yahoo.com>
Date: 13 Mar 2002 08:43:41 -0800
Message-ID: <73919a7e.0203130843.4e6e9a7@posting.google.com>

Hello,

Here is the problem:

table TEST1 has 1,000,000 rows inserted from a script table TEST2 is:

create table TEST2 (

   FILE_ID              NUMBER                           not null,
   ATTRIBUTE_NAME       VARCHAR2(255)                    not null,
   ATTRIBUTE_VALUE      VARCHAR2(255),

   constraint pk_test primary key (FILE_ID, ATTRIBUTE_NAME),    constraint fk_test foreign key (FILE_ID)

         references OTHER_TABLE (FILE_ID) )
organization

    index

        storage
        (
            initial 100M
            next 70M
        )
        pctthreshold 50

/

which structure is identical to TEST1 (apart from organisation, TEST1 has conventional one)

When I try to execute:

insert /*+ APPEND PARALLEL(TEST2, 2)*/ into TEST2 select * from TEST1

After several minutes of thinking Oracle comes up with the error:

ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfbbsearch-7], [125], [], [], [],
[], [], []
both tables reside in dictionary managed tablespaces and all the inserted data fit initial extent of TEST2.

Could anyone help me out and tell where the problem is?

Thanks a lot,
Vlad. Received on Wed Mar 13 2002 - 10:43:41 CST