Re: Index Organized tables: Please explain use?

"Suri, Deepak" wrote:

> That's the one Hannah !
>
> Hey, and I really like your approach of going through the Oracle "Bible(s)".
> I can remember a time when I used to find time to do that myself, and I used
> to love it ! Please don't hesitate to throw any questions/comments you have
> to the wonderful folks on this list, I am sure everyone will appreciate it.
>
> Oh and by the way while we are on the topic of lack of time, does anyone
> know of a way to request more than 24 hours in a day ??? :-)

Fly against the Earth spin ;-)

>
>
> deepak
>
> -----Original Message-----
> Sent: Friday, November 10, 2000 10:07 AM
> To: Multiple recipients of list ORACLE-L
>
> Are you referring to the Index Internals Article by dan Hotka? If so,
> looks
> like it is still current, and I found it. Thanks.
>
> Hannnah
>
> "Suri, Deepak" <DSuri_at_oxhp.com> on 11/10/2000 09:05:50 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
> There was an excellent explanation on IOTs in "Oracle Professional" by
> Pinnacle Publications a few issues ago. You might be able to find it in
> their archive at www.pinpub.com
> Let me know if you can't find it, and I'll dig up my issue and fax you a
> copy...
>
> deepak
>
> -----Original Message-----
> Sent: Friday, November 10, 2000 7:05 AM
> To: Multiple recipients of list ORACLE-L
>
> Hello List!
>
> I'm having trouble comprehending the idea of an Index Organized table.
> The
> Oracle 8i DBA Bible has this paragraph in it:
>
> An index-organized table is one in which the entire table is created as
> an
> index. All the data is stored in the index, and there
> really is no underlying table. Oracle 8i allows secondary indexes to
> be
> created on these tables, allows them to store large
> objects, and allows you to add or modify columns using the ALTER TABLE
> command.
>
> This is all they wrote. But I dont understand how/why one would store data
> in
> the actual index. And if you create an index, don't you need to create it
> on a
> specific table? And if there is NO table, then HOW could you create and
> index
> on it. And why would you do it even if you could?
>
> Thanks in advance,
>
> Hannah
>
> P.S. I have decided to go through the *bible* with a fine tooth comb in
> order
> to deeply ingrain Oracle 8i (use only 7.34 at work still!), hope you don't
> mind
> posts asking for clarification. My goal is to get through the entire book
> stopping to clarify anything that I do not fully 120% grasp or understand:>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Hannah.M.Doran_at_sb.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suri, Deepak
> INET: DSuri_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Hannah.M.Doran_at_sb.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suri, Deepak
> INET: DSuri_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 10 2000 - 11:47:03 CST