Table Space :: The table space is useful for storing the data in the
database.When a database is created two table spaces are created.
a) System Table space :: This data file stores all the tables related to
the system and dba tables
b) User Table space :: This data file stores all the user related tables
We should have seperate table spaces for storing the tables and
indexes so that the access is fast.
Data Files :: Every Oracle Data Base has one or more physical data
files.They store the data for the database.Every datafile is associated
with only one database.Once the Data file is created the size cannot
change.To increase the size of the database to store more data we
have to add data file.
Parameter Files :: Parameter file is needed to start an instance.A
parameter file contains the list of instance configuration parameters
e.g.::
db_block_buffers = 500
db_name = ORA7
db_domain = u.s.acme lang
Control Files :: Control files record the physical structure of the data
files and redo log files
They contain the Db name, name and location of dbs, data files ,redo
log files and time stamp.