Re: what is concept of table in Oracle
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 16 Sep 2008 15:21:32 -0700
Message-ID: <1221603705.334158@bubbleator.drizzle.com>
>> 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 -
Date: Tue, 16 Sep 2008 15:21:32 -0700
Message-ID: <1221603705.334158@bubbleator.drizzle.com>
fitzjarrell_at_cox.net wrote:
> 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
When they hear the word drip some people think:
http://en.wikipedia.org/wiki/Drip_brew
other think:
http://en.wikipedia.org/wiki/Intravenous_therapy
When you get to be my age you think:
http://www.santabarbara.com/Dining/review_read.asp?pk_restaurant=1037
Why not both?
One hour and I'm off to OpenWorld.
And if you find your way to the right suite in the St. Regis on Thursday, at the right time, you will get to meet the "Secret Millionaire."
-- 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:21:32 CDT