Re: Index organized table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Mar 2005 08:16:37 -0800
Message-ID: <1112112997.904945.267280@l41g2000cwc.googlegroups.com>

Checking the 9.2 SQL manual CREATE TABLE syntax it does not appear that the syntax supports explicit naming of the Indexed Organized Table index until you look at the out of line constraint attribute clause:

UT1 > create table marktest2 (

  2    fld1       varchar2(10)
  3   ,fld2       varchar2(10)
  4   ,fld3       number

  5 ,constraint marktest2_pk primary key (fld1)   6 )
  7 organization index
  8 tablespace dataspc
  9 pctfree 10
 10 storage (initial 16K next 16k pctincrease 0 maxextents 32)  11 /

Table created.

UT1 > @obj/idx_tbl

Enter table name: marktest2
Enter owner name: mpowel01

Index Name U Typ Tablespace Initial Next %Incr
------------------------------ - --- ------------ ---------- ----------

---

MARKTEST2_PK U IOT DATASPC 16K 16K 0 This is the only way I have ever done it but on 9.2 you can rename an index so
UT1 > alter index marktest2_pk rename to iot_index;

Index altered.

UT1 > @obj/idx_tbl
Enter table name: marktest
Enter owner name: mpowel01

Index Name                     U Typ Tablespace   Initial    Next

%Incr
------------------------------ - --- ------------ ---------- ----------

---

IOT_INDEX                      U IOT DATASPC      16K        16K

    0

HTH -- Mark D Powell -- Received on Tue Mar 29 2005 - 10:16:37 CST