|
|
Re: how is segment different from object? [message #577531 is a reply to message #573338] |
Mon, 18 February 2013 04:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/5b871f43cdfad02c5cb0a2d739473b59?s=64&d=mm&r=g) |
TuneMyQuery
Messages: 9 Registered: February 2013
|
Junior Member |
![https%3A%2F%2Ftwitter.com%2FTunemyquery](/forum/theme/orafaq/images/twitter.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|