Re: what is concept of table in Oracle

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 Received on Tue Sep 16 2008 - 08:33:24 CDT