Re: Index organized table

"Mark D Powell" <Mark.Powell_at_eds.com> a écrit dans le message de news:1112112997.904945.267280_at_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 --
|

Doh!

Regards
Michel Cadot Received on Tue Mar 29 2005 - 11:21:17 CST