Re: what is concept of table in Oracle
Date: Tue, 16 Sep 2008 06:47:32 -0700 (PDT)
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 ...
David Fitzjarrell Received on Tue Sep 16 2008 - 08:47:32 CDT