les10 man tblspc10 tell me





Managing Storage












The interactions in this eCourse require Javascript to be enabled.



 

Managing Tablespaces


previous|next





Oracle Database XE comprises the following physical database structures:

Control file: Contains entries that specify the physical structure of the database

Data files: Contain all the database data. The content of logical database structures, such as tables and indexes, is physically stored in the data files.

Redo log files: Record all changes made to data

A database is divided into logical storage units called tablespaces that can be used to group related logical structures together. Each database is logically divided into one or more tablespaces. One or more data files are explicitly created for each tablespace to physically store the data of all logical structures in a tablespace.
You have seen how to store and display data in tables. These tables are created in tablespaces. Tablespaces and all the objects they contain are logical objects.


Logical data structures are stored in the physical files of the database,

in data files associated with each tablespace.
 
 
 
 







Wyszukiwarka

Podobne podstrony:
les10 man tblspc20 tell me
les10 man mem20 tell me
les10 man tblspc10 show me
les10 man tblspc20 show me
les10 man mem10 tell me
les10 man usr10 tell me
les10 man usr21 tell me
les10 man usr20 tell me
les10 man set20 tell me
les10 man set10 tell me
les10 man usr10 show me
les10 man mem10 show me
les10 man set10 show me
les10 man usr20 show me
les10 mon?20 tell me
les10 mon?10 tell me
les05 ins tab20 tell me
Geri Halliwell Don t?ll me?by

więcej podobnych podstron