Re: Real simple question from learner

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 28 Mar 2002 04:56:53 -0800
Message-ID: <a20d28ee.0203280456.3fdee252@posting.google.com>

"Jason" <thekiwi_at_dccnet.com> wrote in message news:<CCzo8.178216$eb.9097760_at_news3.calgary.shaw.ca>...
> OK - just looking at the entity-relationships between the following :
>
> Tablespaces
> Segments
> Extents
> Blocks
>
> Pretty sure I got it - just wondering.....in this regard, could a "segment"
> be regarded as the same thing as a "table" ?? Seems like it to me - if not
> why not? How do they differ?

segment = a table or an index or a cluster or a rollback segment etc.

A segment is any database object with a separate distinct fysical implementation (ie a procedure is not a segment)

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Mar 28 2002 - 06:56:53 CST