Re: Index-organized tables

Thank you - I hoped to hear that.

Pavel

"vipan" <dba_at_no_spam.netscape.net> píse v diskusním príspevku news:3F4F239E.3040906_at_no_spam.netscape.net...
> Hi,
>
> You can modify IOT table and coulmns to it.
> IOT table is basically stored in index segment not in table segment and
> is very useful for query which access data using primay keys(e.g. lookup
> table as you mentioned). Data access from IOT table is very fast
> because oracle does not have to do two I/Os(One for index and other for
> table) to get the data.
>
> Thanks
>
> Pavel Vetesnik wrote:
> > Hello,
> >
> > is it possible to modify (alter) index-organized table?
> > In documentation I read, that "you cannot ADD columns to an
index-organized
> > table, but you can alter the definition of an index-organized table.".
But
> > it seems I can do it.
> >
> > To following code surprisingly works for me:
> > ======================================================
> > CREATE TABLE source_type
> > (short_name CHARACTER(3) PRIMARY KEY,
> > name VARCHAR2(25) UNIQUE)
> > ORGANIZATION INDEX
> > STORAGE (INITIAL 20k NEXT 10k PCTINCREASE 0);
> >
> > ALTER TABLE source_type ADD (some_column VARCHAR2(500))
> > ======================================================
> >
> > So how it is? Can IOT table be modified or not (or sometimes not).
> >
> > Do you think it is good idea to use IOTs for small lookup tables, that
are
> > updated very seldom?
> >
> > Thank you in advance,
> > Pavel
> >
> >
>
Received on Fri Aug 29 2003 - 06:16:48 CDT