Re: what is concept of table in Oracle

From: Palooka <>
Date: Thu, 18 Sep 2008 00:32:58 +0100
Message-ID: <EsgAk.5$6m1.4@newsfe16.ams2>

William Robertson wrote:
> On Sep 16, 9:29 am, fatshaw <> wrote:

>> i want to know what is concept of table in Oracle?is there any
>> relations to segment?

> A segment is just a thing in the database taking up physical space,
> such as a table, index, cluster or undo segment. Don't worry about
> segments.
> Tables on the other hand are how all data in a relational database is
> stored, managed, queried and presented. Asking what a table is in
> Oracle is rather like asking what an object is in Java, or what a pipe
> is in plumbing.

Agree. Much better for OP to think of a table as a purely logical thing, and forget about the physical stuff for now.

To OP: Study entities/attributes/rows/tuples/relations and all the Codd stuff. Only then worry about how Oracle physically implements tables.

Palooka Received on Wed Sep 17 2008 - 18:32:58 CDT

Original text of this message