| |
 |
|
Oracle Tips by Burleson |
Oracle Datafiles
Datafiles are the physical implementations of Oracle tablespaces.
Tablespaces are the logical units of storage (containers) that would
roughly compare to volume groups in an operating system. Each
tablespace can have hundreds of tables, indexes, rollback segments,
constraints, and other internal structures mapped into it. In
return, these are then mapped into the datafiles that correspond to
the tablespaces. Only a limited number of datafiles can be
associated with a tablespace. The total number of datafiles for the
entire database is set by the MAXDATAFILES parameter at creation.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
