Wednesday, August 31, 2011

STORAGE STRUCTURE

DATABASE STORAGE STRUCTURE:

The database is just a set of files present on disk. These files are created when we create the Database using the 'CREATE DATABASE' statement.



When looking at server level, we may find the files as .log .trc .trm .dbf .ctl. Oracle uses the logical structure to organize the files internally.

The data dictionary maintains the relationship between the physical and logical structure


I) Physical Database Structure:

CONTROL FILES