Basic HTML version of Foils prepared 7 October 97

Foil 18 Major Schema Objects in Oracle - Tablespace II

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
This figure illustrates
Each Oracle DB 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
The combined size of a tablespace's data files is the total storage capacity of the tablespace (SYSTEMS has 2M while USERS has 4M)
The combined storage capacity of a database's tablespaces is the total storage capacity of the database (6M in example above)

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998