Re: Primary index storage

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/17
Message-ID: <32B6C6CB.2CF3@qrcsun.qrc.org>#1/1

Angelito Dizon wrote:
>
> Since Oracle automatically creates primary indexes, how can I specify
> storage parameters for a primary index?

  You can set storage clause for a primary index. For example:

  CREATE TABLE test
  (col1 NUMBER(1) PRIMARY KEY

                    USING INDEX PCTREE 50
                                STORAGE (INITIAL 10K),

   col2 ...);

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Tue Dec 17 1996 - 00:00:00 CST