Yoaga

• Jun 5th, 2005

 

Tablespace, segments, extens, data Blocks. 
 
A logical unit of storage of databse is called Tablespace. 
 
Segments is a space alloocated for a specific logical storage structure within a tablespce. 
 
Extents: Space allocated to a segments. 
 
Datablocks: Oracle server manage the storage space in the datafiles in units is called data blocks or oracle blocks. 

rajesh

• Sep 1st, 2005

 

thanks for providing for this.it is very usefull for us 
thanx

shalini

• Sep 12th, 2005

 

Oracle database constitutes of tablespaces which are made of segments which inturn have extents,which are made out of oracle blocks.

RAVI

• Jan 8th, 2007

 

Components of Logical Database:--

1. Tablespace - A tablespace consist Datablock, Extends and Segments

2. Schema - A schema includes --

Index, Tables, Views, Clusters, Stored Procedures, Triggers and Sequences

Thanks

waqas

• Jul 22nd, 2007

 

Data objects are used to stored data when needs to grow take chunks of space that is called extents and an data objects multiple extents are stored in segment.

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh 

• Apr 5th, 2009

 

Oracle logical structure follows the order like
Tablespace
Segments
Extents
Datablocks

Oracle database consists of tablesapces (one or more tablespace forms database)
Segments is the area in which on oracle object sores in a tablespace.
One Oracle object will be in the one segment only.
Segment needs to extent the size of the segment then the memory will be allotted in extents.
Each extent is the collection of Oracle blocks.
So the logical architecture of the Oracle follows like above.

RajiPeter

 Profile Answers by RajiPeter 

• Feb 17th, 2010

 

An ORACLE database's logical structure is determined by
1. One or more tablespaces.
2. The database's schema objects
(e.g., tables,views,indexes,clusters, sequences, stored procedures).

The logical storage structures, including tablespaces, segments, and extents, dictate how the physical space of a database is used. The schema objects and the relationships among them form the relational design of a database.

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Feb 19th, 2010

 

Oracle Database comprises of Physical and Logical Structure.

Logical structures are intangible.....
and it includes: -

1) Tablsespace
2) Segments
3) Extents
4) Data blocks.

Remember Tables are also logical only..



Regards
Dharmendra Jaiswal

gurbux

 Profile Answers by gurbux 

• Jul 18th, 2010

 

Logical database structures are:
Blocks: Smallest unit of database storage.
Extents: Blocks combined make extents.
Segments: More than one extent make segments. Tables, indexes, views etc are segments.
Tablespace: More than one segments are stored in tablespaces.

Default tablespace provided by Oracle is SYSTEM and SYSAUX

arunkumarb6

 Profile Answers by arunkumarb6 

• Jun 24th, 2011

 

logical database structure of database are 

tablespace and segments..

Dharma Kotha

 Profile Answers by Dharma Kotha 

• Oct 10th, 2011

 

Datablocks are physical storage.

csanthoshreddy

 Profile Answers by csanthoshreddy 

• Mar 6th, 2012

 

the logical components of database are tablespaces, segments, extents, datablocks. datablock is the smallest unit of oracle I/0.

doc123

 Profile Answers by doc123 

• Mar 22nd, 2012

 

Logical Structure of Oracle is following.

Tablespace =>Schema => Segments => Extent => Oracle Block. (Remember Oracle block is smallest logical unit).