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.
Above answer was rated as good by the following members: bhatnagar_neeraj
RE: What are the components of Logical database...
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.
RE: What are the components of Logical database structure of ORACLE database?
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