Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Anyone saw this bug:

Anyone saw this bug:

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Mon, 8 May 2000 18:28:42 -0400
Message-Id: <10491.105198@fatcity.com>


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                                        KEEP
Received on Mon May 08 2000 - 17:28:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US