This chapter introduces the basic concepts and techniques for database space management, including tablespace, data files, control file, storage management parameters, and rollback . Upon completion of this chapter, you will accomplish the following:

1. Understand basic concept of database tablespace (logical structure) and its relation to data files (physical structure).
2. How to create tablespace (logical structure).
3. How to alter tablespace.
4. How to display information about data files (physical) and tablespaces (logical).
5. Understand what is control file for.
6. How to manage control file.
7. Understand the storage parameters and know how to change them.
8. Understand the application of rollback segments.
9. Understand why and when a temporary tablespace is needed.
10. Understand some more advanced topics related to large objects and partitioning tables.

 

Class Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University