RE: Index table last update?

It has to do with the organization and storage structure. An IOT is just that, "index-organized". A heap table is modeled like a heap. A pile of storage is allocted and used. Then, another pile of storage is added to the "heap". It's named after the type of data structure that used to store the data.

-Mark
On Wed, 2002-09-11 at 09:08, Naveen Nahata wrote:
> What's a heap table? I can understand that it is the general table (not the
> IOT), but why the term 'heap table'?
>
> Regards,
> Naveen
>
> -----Original Message-----
> Sent: Wednesday, September 11, 2002 5:58 PM
> To: Multiple recipients of list ORACLE-L
>
>
> >----- Original Message -----
> >From: "O'Neill, Sean" <Sean.ONeill_at_organon.ie>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Wed, 11 Sep 2002 03:13:21
> >
> >Is there a way to determine when an index table was
> >last updated?.=0D
> >=0D
> >-------------------------=0D
> >Se=E1n O' Neill=0D
> >Organon (Ireland) Ltd.=0D
> >[subscribed: digest mode] =0D
>
> The answer is the same as with heap tables.
>
> Regards,
>
> Stephane Faroult
> Oriole

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it