Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Anyone saw this bug:
Oracle 8.0.5.1
Solaris: 2.6
SQL> create table testbug1 ( c1 char (250),c2 char(250),c3 char(250),c4 char(250));
Table created.
SQL> begin
2 for i in 1..10000 loop
3 insert into testbug1 values ('A','B','V','F');
4 end loop;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> create index testbugh on testbug1 ( c1,c4) parallel (degree 2) storage(buffer_pool keep);
Index created.
SQL> select degree,buffer_pool from dba_indexes where index_name =
'TESTBUGH';
DEGREE BUFFER_ ---------------------------------------- ------- 2 DEFAULT
SQL> drop index testbugh;
Index dropped.
SQL> create index testbugh on testbug1 ( c1,c4) noparallel storage(buffer_pool keep);
Index created.
SQL> select degree,buffer_pool from dba_indexes where index_name =
'TESTBUGH';
DEGREE BUFFER_ ---------------------------------------- ------- 1 KEEPReceived on Mon May 08 2000 - 17:28:42 CDT
![]() |
![]() |