July 2015
Intermediate to advanced
288 pages
7h 26m
English
Oracle tablespaces are the basic “logical” containers where users place all database objects that require or consume disk space. For example, basic tables and indexes consume disk space, so they must reside within a tablespace. Other database objects such as directories and external tables don’t consume space, so they merely require an entry in the data dictionary. For those objects that consume space, a key database management task is to make sure that sufficient room exists for both today’s and tomorrow’s needs. You want to avoid Oracle error messages such as “cannot allocate extent.” Thus tablespace and data file management are key, routine administrative tasks.
Because Toad originally began as a developer’s tool and ...