Re: what is concept of table in Oracle
Date: Tue, 16 Sep 2008 06:28:16 -0700
> 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
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Sep 16 2008 - 08:28:16 CDT