Re: what is concept of table in Oracle
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 16 Sep 2008 15:16:39 -0700
Message-ID: <1221603399.215587@bubbleator.drizzle.com>
>> gazzag wrote:
>> 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
Date: Tue, 16 Sep 2008 15:16:39 -0700
Message-ID: <1221603399.215587@bubbleator.drizzle.com>
gazzag 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
Caffeine in the morning.
Scotch in the evening.
Don't get it confused. <g>
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Sep 16 2008 - 17:16:39 CDT