Re: what is concept of table in Oracle

From: <fitzjarrell_at_cox.net>
Date: Tue, 16 Sep 2008 06:47:32 -0700 (PDT)
Message-ID: <7d56794f-6fae-40d3-9143-8b60d2b45208@a1g2000hsb.googlegroups.com>


On Sep 16, 8:33 am, gazzag <gar..._at_jamms.org> wrote:
> On 16 Sep, 14:28, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > gazzag wrote:
> > > On 16 Sep, 09:29, fatshaw <fats..._at_gmail.com> wrote:
> > >> i want to know what is concept of table in Oracle?is there any
> > >> relations to segment?
>
> > > Indeed.  A table is made up of segments which, in turn, are made up of
> > > extents.
>
> > >http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro....
>
> > > HTH
>
> > > -g
>
> > Correction. A segment is made up of extents which are made up of
> > blocks. The only table types made up of segments are partitioned
> > and IOT. A heap table is always a single segment.
> > --
> > Daniel A. Morgan
> > Oracle Ace Director & Instructor
> > University of Washington
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org
>
> Agreed.  You're always far more on the ball earlier on in the day than
> I am, Daniel ;)
>
> -g- Hide quoted text -
>
> - Show quoted text -

It's that Starbuck's IV, I think ...

<g>

David Fitzjarrell Received on Tue Sep 16 2008 - 08:47:32 CDT

Original text of this message