Home » RDBMS Server » Server Administration » how is segment different from object?
how is segment different from object? [message #573334] Wed, 26 December 2012 21:08 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member

Are the terms object and segment same ??
what are the differences between them??
what are similarities between them?
Re: how is segment different from object? [message #573338 is a reply to message #573334] Wed, 26 December 2012 21:29 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm
Re: how is segment different from object? [message #577531 is a reply to message #573338] Mon, 18 February 2013 04:27 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 58938
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
Previous Topic: nls_database_parameters vs nls_instance_parameters
Next Topic: Shared Server problem
Goto Forum:
  


Current Time: Fri Aug 29 18:09:05 CDT 2014

Total time taken to generate the page: 0.10287 seconds