crBitmapIdx.txt
10-20-2001 Bikle
------------------

This file displays some simple syntax for building a partitioned index
on the event table.


CREATE BITMAP INDEX 
EVENT_EVENT_TYPE_IX ON EVENT (EVENT_TYPE )
local (PARTITION p2 STORAGE (INITIAL 20m next 20m PCTINCREASE 0 MAXEXTENTS 2999)
TABLESPACE BIKLE_INDEX );

Here is a screen dump:

testbikle01-oracle-% sqg

SQL*Plus: Release 8.1.6.0.0 - Production on Sat Oct 20 21:39:42 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

21:39:42 SQL> @crBitmapIdx.sql
21:39:48 SQL> SET ECHO ON
21:39:48 SQL>
21:39:48 SQL> --
21:39:48 SQL> -- crBitmapIdx.sql
21:39:48 SQL> --
21:39:48 SQL>
21:39:48 SQL> CREATE BITMAP INDEX
21:39:48   2  EVENT_EVENT_TYPE_IX ON EVENT (EVENT_TYPE )
21:39:48   3  LOCAL (PARTITION P2 STORAGE (INITIAL 20M NEXT 20M PCTINCREASE 0 MAXEXTENTS 2999)
21:39:48   4  TABLESPACE BIKLE_INDEX );

Index created.

21:39:49 SQL>
21:39:49 SQL> EXIT