What are the components of Logical database structure of ORACLE database?

Tablespaces and the Database's Schema Objects.

Showing Answers 1 - 8 of 8 Answers

puneet soni

  • Feb 17th, 2006
 

there are two types of database 1) logical database 2)physical databaselogical database consist of tablespaces....and a tablespace consist of one or more segments....a segment consist of one or more extents.....an extent consist of contigious oracle data blocks.logical database contain objects of users such as tables,indexes etc.

Mohammed Abdul Afroze

  • Sep 20th, 2007
 

Components of a Logical Structure of a Database are as follows:

Tablespaces--->Segments---->Extents----->Data Blocks.

  Was this answer useful?  Yes

vpramn

  • Sep 8th, 2008
 

Oracle Database has Physical and Logical Structure. In Logical Structure contains System tablespace and no of tablespace in database. these tablespace contains datafiles from physical database datafiles

  Was this answer useful?  Yes

suraj bansode

  • Oct 13th, 2016
 

The logical components are Database, Schema, Tablespace, Tables.

  Was this answer useful?  Yes

eunice laurence

  • Nov 4th, 2016
 

The components of logical database structure are
Datablock
Extent
Segment
Datafiles

  Was this answer useful?  Yes

Heena

  • Sep 17th, 2017
 

Tablespaces, Segments, Extent, Data blocks

  Was this answer useful?  Yes

mosin

  • Jan 18th, 2018
 

Tablespace
Segments
Extent

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions