Re: what is concept of table in Oracle
From: Palooka <nobody_at_nowhere.com>
Date: Thu, 18 Sep 2008 00:32:58 +0100
Message-ID: <EsgAk.5$6m1.4@newsfe16.ams2>
>
> 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.
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 <fats..._at_gmail.com> 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