Re: Oracle 9i insertion problem

Vlad wrote:
>
> 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?
>

Obviously it is a bug in the software. Contact Oracle support.

U.

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!