|
|
|
|
| Re: how is segment different from object? [message #577531 is a reply to message #573338] |
Mon, 18 February 2013 04:27   |
 |
TuneMyQuery
Messages: 9
Registered: February 2013
|
Junior Member |
|
|
Hi,
A segment consists of actual data stored in the database : table, index, table partition, index partition...
An object might contain one segment (table, index) or several segments (partitioned table, partitioned index), or might not. For example, a view (which is an object) does not contain actual data, it's only a logical definition, stored somewhere in the data dictionary. The same for a PL/SQL package, for example.
Best regards,
Emmanuel
|
|
|
|
| Re: how is segment different from object? [message #577543 is a reply to message #577531] |
Mon, 18 February 2013 05:27 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:A segment consists of actual data stored in the database
It is almost true (depending on what you name "data", if you mean anything then it is true).
A segment is a physical part of an object.
All this stuff is explain in details in Database Concepts everyone should read.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
